Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Scripting Object Permissions

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-09-06 : 23:47:40
Brad writes "Is there any easy way to script just object permissions for a specific user? Say I have a user named "dennis", what I want is to be able to automatically create a script that scripts all of that user's object permissions in a database, whether they are SELECT, UPDATE, etc, for all the objects in the database this user has permissions for. I can sort of do this using SQL Server 7.0's Enterprise Manager's "Generate SQL Scripts option", but I also get a lot of scripting I don't want."
   

- Advertisement -