Grants Lost on Table when Table Dropped.....
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Grants Lost on Table when Table Dropped.....

  1. #1
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Hi,

    We are currently working on a development system which also is our testing system .

    We had created a number of Roles and assigned these Roles to users. These Roles in turn are Granted Object Priveleges on certain objects in the schema.

    Now since this is a development system developers constantly drop, recreate, compile procedures/packages tables etc at the same time when testers are testing the application.

    Whenever a table /procedure or any object is dropped the grant on that object to the role is also dropped. i understand that this is logical but it causes us a headache everytime it does so.

    Is there any way to avoid doing this where i have to regrant the priveleges again and again.


    Thanks
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Use two different schemas for development and test.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width