This discussion is archived
2 Replies Latest reply: Aug 28, 2012 10:12 AM by vlethakula RSS

Possible to revoke right for some tables but auto grant for all new ones ?

958489 Newbie
Currently Being Moderated
Hi experts

I was wondering. I have two schemas SA and SB.
Is it possible to revoke all right for all tables in SA (statically)
but to grant all privileges to all tables in SB ?
The thing is, when new tables are created in SB, the should automatically have all privileges on these tables...

I just want to restrict a user from updating, deleting tables in a specific schema, without having to run a script every time I create a new table in the other schema...

If you have questions, please ask.

Thanks in advance !


  • Correct Answers - 10 points
  • Helpful Answers - 5 points