Solved

SQL security

Posted on 2012-03-20
3
177 Views
Last Modified: 2012-03-20
If we use the grant or deny to restrict access to certain database fields, do we have to use sql authentication for it to work. We currently use Windows Authentication.
0
Comment
Question by:qbjgqbjg
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 17

Expert Comment

by:Barry Cunney
ID: 37743498
There should already be a Login principal for your Windows user in SQL Server under Security | Logins
You can create a database user principal in the required database associated with the Login principal
CREATE USER <yourDBUser> FOR LOGIN <YourWindowsUser>

You can then give whatever permissions you required to <yourDBUser>
0
 
LVL 17

Accepted Solution

by:
Barry Cunney earned 500 total points
ID: 37743517
You could also create a Database Role which has the necessary field(column) permissions and associate this role with the user
0
 

Author Closing Comment

by:qbjgqbjg
ID: 37743791
Thanks. I think this will work.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question