Grant Privileges

You can grant users various privileges to tables. These privileges can be any combination of SELECT, INSERT, UPDATE, DELETE, REFERENCES, ALTER, INDEX, or ALL.

 

GRANT SELECT ANY CUBE TO BARANYILDIZ ;

GRANT SELECT ANY TABLE TO BARANYILDIZ ;

GRANT SELECT ANY DICTIONARY TO BARANYILDIZ ;

GRANT CREATE ANY PROCEDURE   TO BARANYILDIZ;

GRANT EXECUTE ANY PROCEDURE   TO BARANYILDIZ;

GRANT DROP ANY TABLE    TO BARANYILDIZ;

GRANT DROP ANY PROCEDURE   TO BARANYILDIZ;

GRANT  ALTER ANY PROCEDURE   TO BARANYILDIZ;

GRANT CREATE ANY DIRECTORY  TO BARANYILDIZ;

 

About baranyildiz

I am Computer Engineer. Oracle & SQL Server Database,Goldengate,Guardium,Tableau , Exadata Machine administrator 6 years.I took part in many different projects in energy sector and customer information systems. I worked on sql server, oracle consolidation,migration, upgrade projectsMail : [email protected]

Leave a Reply

Your email address will not be published. Required fields are marked *