GRANT
CREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX, CREATE ANY PROCEDURE,
ALTER ANY TABLE, ALTER ANY PROCEDURE,
DROP ANY TABLE, DROP ANY VIEW, DROP ANY INDEX, DROP ANY PROCEDURE,
SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE
TO username;
grant create sequence to oatest
grant unlimited tablespace to oatest;
grant debug connect session to oatest;
CREATE SYNONYM vip FOR orcl.vip
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/21302630/viewspace-1571847/ ,如需转载,请注明出处,否则将追究法律责任。