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;

 


 1,432 views last month,  183 views today

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 projects Mail : baranbereketyildiz@hotmail.com

Check Also

blank

Alter System Flush Shared pool in Oracle

Hi, I will explain Alter System Flush Shared pool in Oracle in this post.  4,723 views …

Leave a Reply