Seeking alternate method to Set User Permissions | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Seeking alternate method to Set User Permissions

Hi, currently we set the database user permission on the objects in the database by going into Enterprise Manager -> database -> users and then for a specific user opening the properties and clicking permissions. From there setting the perms (Select, Update, Delete, Exec, DRI) for each object…. salada work. Pleazzzz tell me of another way to do this? Query analyzer? Thanks-salot.

Check GRANT in BOL.
Luis Martin
Moderator One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.