oracle 获得当前用户的权限

最新推荐文章于 2024-04-12 16:03:29 发布

最新推荐文章于 2024-04-12 16:03:29 发布 · 156 阅读

文章标签：

#数据库

本文展示了如何使用Oracle SQL查询来查看用户LANDUSER被授予的各种系统权限，包括表、视图、触发器等的创建与修改权限，以及执行过程和使用特定角色的权限。

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