Site icon IT Tutorial

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;

 


 2,612 views last month,  1 views today

Exit mobile version