Re: What privilege needs to be granted?

> Even worse, then - wonder what the "set of privileges which worked on
> oracle 8.1.6" were?

Frank, I have the following set for the schema U2 as mentioned in the above conversation:

ALTER ANY PROCEDURE

ALTER ANY TRIGGER               
ALTER SYSTEM                    
CREATE ANY PROCEDURE            
CREATE ANY TRIGGER              
CREATE PUBLIC SYNONYM           
DROP ANY PROCEDURE              
DROP ANY TRIGGER                
DROP PUBLIC SYNONYM             
EXECUTE ANY PROCEDURE           
GRANT ANY PRIVILEGE             
SELECT ANY TABLE                
UNLIMITED TABLESPACE            

Just got oracle 9.2 on XP working after granting the basetables of T1 with grant option, as stated in the Oracle 9i concept:

Additionally, in order to grant other users access to your view, you must have received object privileges to the base objects with the GRANT OPTION clause or appropriate system privileges with the ADMIN OPTION clause. If you have not, grantees cannot access your view.

Thanks, Hans, for pointing out the excact chapters in the documents.

Ping Received on Sun Jan 04 2004 - 08:32:41 CET