Re: "grant select" for all tables: Is it possible?

Jaap, how did you try it? Did you try to issue the grant via execute immediate in the DDL trigger or did you call a procedure owned by userA or a DBA to issue the grant?

I can believe that the process is not allowed but I am thinking there is probably a way around the restriction. If nothing else by submitting a job via dbms_job that performs the dirty work.

I wonder when I can take the time to try this?

• Mark D Powell --