Posted by Ed Murphy on 10/01/07 16:59

abu hisham wrote:

> You can grant permissions dynamically in this way to all db objects:
> /* tables and views*/
> select 'Grant select,insert,update,delete on '+name+ ' to USER'
> from sysobjects
> where xtype in ('U','V')
>
> /*Stored procedures*/
> select 'Grant exec on '+name+ ' to USER'
> from sysobjects
> where xtype in ('P')

To clarify, this will not directly grant the permissions, but will
output SQL code that can be copy+pasted into Query Analyzer and
executed to grant the permissions.

• Next in forum: Simple recovery model affect performance?
• Prev in forum: Re: The best way to use the Database Engine Tuning Advisor
• Thread view: Re: How Do I give EXECUTE Permissions on Stored Procedures?

[Reply to this message]