Oracle 11g: USER_TAB_PRIVS and ALL_TAB_PRIVS

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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值