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

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

  1. #1
    Join Date
    Mar 2001
    New York , New York

    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.


    You can if you think you can.

  2. #2
    Join Date
    Nov 2000
    Use two different schemas for development and test.
    Jeff Hunter
    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