Oracle 11g: USER_TAB_PRIVS and ALL_TAB_PRIVS

最新推荐文章于 2023-05-30 14:19:42 发布

转载最新推荐文章于 2023-05-30 14:19:42 发布 · 166 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/duadu/archive/2012/02/10/6335532.html

文章标签：

#数据库

本文详细展示了如何使用SQL查询语句分析用户在特定数据库表中的权限，包括查看、更新、插入和删除操作。通过对比`USER_TAB_PRIVS`和`ALL_TAB_PRIVS`表中的数据，了解用户在不同表上的不同权限。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SQL> SET LINESIZE 400
SQL> SET PAGESIZE 400

SQL> SELECT * FROM USER_TAB_PRIVS WHERE GRANTEE='XIAYE';

GRANTEE                        OWNER                          TABLE_NAME                     GRANTOR                PRIVILEGE                                GRA HIE
------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------------------------------------- --- ---
XIAYE                          SYS                            SHIPS                          SYS                    UPDATE                                   NO  NO
XIAYE                          SYS                            SHIPS                          SYS                    SELECT                                   NO  NO
XIAYE                          SYS                            SHIPS                          SYS                    INSERT                                   NO  NO
XIAYE                          SYS                            SHIPS                          SYS                    DELETE                                   NO  NO

SQL> SELECT * FROM ALL_TAB_PRIVS WHERE GRANTEE='XIAYE';

GRANTOR                        GRANTEE                        TABLE_SCHEMA                   TABLE_NAME                     PRIVILEGE                                GRA HIE
------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------------------------------------- --- ---
SYS                            XIAYE                          SYS                            SHIPS                  UPDATE                                   NO  NO
SYS                            XIAYE                          SYS                            SHIPS                  SELECT                                   NO  NO
SYS                            XIAYE                          SYS                            SHIPS                  INSERT                                   NO  NO
SYS                            XIAYE                          SYS                            SHIPS                  DELETE                                   NO  NO

转载于:https://www.cnblogs.com/duadu/archive/2012/02/10/6335532.html