oracle 获得当前用户的权限

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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值