select 'GRANT '||sp||' to '||user from
(select s.privilege sp from USER_SYS_PRIVS s union
select r.granted_role from USER_ROLE_PRIVS r)
我的权限如下:
1GRANT ALTER ANY INDEX to LANDUSER
2GRANT ALTER ANY TABLE to LANDUSER
3GRANT ALTER ANY TRIGGER to LANDUSER
4GRANT ALTER SYSTEM to LANDUSER
5GRANT CONNECT to LANDUSER
6GRANT CREATE ANY SYNONYM to LANDUSER
7GRANT CREATE ANY TABLE to LANDUSER
8GRANT CREATE ANY TRIGGER to LANDUSER
9GRANT CREATE ANY VIEW to LANDUSER
10GRANT CREATE PUBLIC SYNONYM to LANDUSER
11GRANT CREATE SEQUENCE to LANDUSER
12GRANT DBA to LANDUSER
13GRANT DELETE ANY TABLE to LANDUSER
14GRANT DROP ANY PROCEDURE to LANDUSER
15GRANT DROP ANY SYNONYM to LANDUSER
16GRANT DROP ANY TABLE to LANDUSER
17GRANT DROP ANY TRIGGER to LANDUSER
18GRANT DROP ANY VIEW to LANDUSER
19GRANT DROP PUBLIC SYNONYM to LANDUSER
20GRANT EXECUTE ANY PROCEDURE to LANDUSER
21GRANT EXP_FULL_DATABASE to LANDUSER
22GRANT IMP_FULL_DATABASE to LANDUSER
23GRANT SELECT ANY TABLE to LANDUSER
24GRANT UNLIMITED TABLESPACE to LANDUSER
25GRANT UPDATE ANY TABLE to LANDUSER