grant all privls on a schema to a user
1.CREATE USER PSDVIEW
IDENTIFIED BY PSD123
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
GRANT CONNECT TO PSDVIEW;
GRANT CREATE SESSION TO PSDVIEW;
2.
sqlplus
SQL> set feedback off heading off term off;
SQL> set pages 0 trim on trims on lines 32767 long 999999;
SQL> set echo off;
SQL> spool PSDVIEW2.sql;
SQL> select 'GRANT SELECT ON DWMGRPRD.' || table_name || ' to PSDVIEW;'
from DBA_tables WHERE OWNER = 'DWMGRPRD'; 2
Spool off;
@***.sql
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29551564/viewspace-2085823/ ，如需转载，请注明出处，否则将追究法律责任。
