November 13, 2008 at 12:50 am
when we login sql server using window authontication that time i want to give security to select/insert/update/delete how to set this security....plz send me replly
November 13, 2008 at 7:55 am
its the same procedure that you would use for sql logins
grant select, update, insert, delete on objectname to domain\userorgroupname
hth,
john
November 15, 2008 at 8:40 pm
how?
November 15, 2008 at 10:24 pm
Granting permissions on object level is done the same way regardless the authentication mode that the login is using. You just need to run grant statement. For example:
Grant select on MyTable to UserName.
For more details you can read on grant statement at Books On Line.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 16, 2008 at 9:11 pm
THANKS.............!:):)
December 1, 2008 at 7:19 am
Its
grant select on object_name to "domain\username"
double quotes should be there for domain user
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply