Skip to main content
Database Administrators

Return to Question

Tweeted twitter.com/#!/StackDBAs/status/170565232358469632
added 4 characters in body; edited tags
Source Link
Leigh Riffel
Leigh Riffel
  • 23.9k
  • 17
  • 79
  • 155

I have two users A and B. I want Bto grant B the permessionpermission to cratecreate, drop, etc. all tables in A's schema. As far as I can see, I can grant B full access to all schemas not a specific one. Is this correct?

I have two users A and B. I want B grant the permession to crate, drop, etc. all tables in A's schema. As far as I can see, I can grant B full access to all schemas not a specific one. Is this correct?

I have two users A and B. I want to grant B the permission to create, drop, etc. all tables in A's schema. As far as I can see, I can grant B full access to all schemas not a specific one. Is this correct?

Source Link
Michael-O
Michael-O
  • 510
  • 3
  • 10
  • 22

Grant create permission on a specific schema in Oracle 11g

I have two users A and B. I want B grant the permession to crate, drop, etc. all tables in A's schema. As far as I can see, I can grant B full access to all schemas not a specific one. Is this correct?