How To Transfer or Script SP Permissions

[Denise]

Hello,

I'm using MS SQL Server 7.0--I'm trying to transfer all my objects to another
database. I used the database scripting, and selected all options. It did
not create permissions for my stored procedures. Is there a way to script
the permissions to execute all my stored procedures? Or do I have to manually
select the permissions for each stored procedure?

Thanks,
Denise

[C. E. Buttles]

You can give your permissions as part of the stored procedure. The problem
with this is that your groups and users may be different on the next server.
List them at the end.

You should be able to modify the scripts, also, but be careful.

Or you can do it manually.

If you are using roles, then the following from BOL should be the best way
to go:

How to grant permissions on multiple objects to a user, group, or role
(Enterprise Manager)
To grant permissions on multiple objects to a user, group, or role

Expand a server group; then expand a server.
Expand Databases; then expand the database to which the user, group, or role
belongs.
Click Users or Roles, depending on the type of user, group, or role to which
permissions will be granted.
In the details pane, right-click the user, group, or role to which
permissions will be granted, point to All Tasks, and then click Manage
Permissions.
Select List all objects.
Select the permission to grant for each object. A check indicates a granted
permission. Only permissions applicable to the object are listed.
See Also
Allowing Access by Granting Permissions






"Denise" <im_denise@hotmail.com> wrote in message
news:38cd72c7$1@news.devx.com...
>
> Hello,
>
> I'm using MS SQL Server 7.0--I'm trying to transfer all my objects to
another
> database. I used the database scripting, and selected all options. It
did
> not create permissions for my stored procedures. Is there a way to script
> the permissions to execute all my stored procedures? Or do I have to
manually
> select the permissions for each stored procedure?
>
> Thanks,
> Denise
>