How To Transfer or Script SP Permissions


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: How To Transfer or Script SP Permissions

  1. #1
    Denise Guest

    How To Transfer or Script SP Permissions


    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


  2. #2
    C. E. Buttles Guest

    Re: How To Transfer or Script SP Permissions

    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
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center