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...