Schema Grants
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Schema Grants

  1. #1
    Join Date
    Dec 2001
    Posts
    337

    Schema Grants

    Hi all,

    I have two schemas.Is it possible to grant SCHEMA2 select,insert,update,delete grants on SCHEMA1 objects at a schema level rather going through each object and grant the priveledges? If so could anyone please let me know?

    Thanks in advance,
    Chucks

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    no

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,003
    You can grant to a role, and that give that role to the other schema. However, if you need the grants for use in stored procedures then you need direct grants.
    this space intentionally left blank

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    that wasnt the question, the question was to grant access to all objects in a schema at the same time. Which you cannot do

  5. #5
    Join Date
    Dec 2001
    Posts
    337
    Thanks Guys,

    There is a limitation to this that if SCHEMA1 was add/drop more objects then I would have to the grants for SCHEMA2. Becomes a nuisance if there is a varyin range!

    Thanks
    Chucks

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    yes it is a nuisance, but a good one in my opinion. If Oracle had this ability it would get abused and people would end up with way more priveleges than they need just because it was quicker to grant all rather than actually work out what was needed

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