Can anyone please help me with a script to do the following in SQL Server 2005?
I would like to grant a login (already exists in the database) to have SELECT only permission on a specific database with a specific table.
Any help is appreciated. Thanks!
You can try this script
use [database]
GRANT select on [table] to [user]
details can be found on
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/a760c16a-4d2d-43f2-be81-ae9315f38185.htm
No comments:
Post a Comment