2 Replies Latest reply: Aug 28, 2012 12:12 PM by vlethakula RSS

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

      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 !