Solved

SQL security

Posted on 2012-03-20
3
174 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
  • 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

867 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now