Pass Oracle Database Permissions

Oracle Database permission transfer 1. system permission transfer super administrator grants lisi the administrative permission to modify any table: SQL> grant alter any table to lisi with admin option; authorization successful. View system permissions of lisi users at www.2cto.com: SQL> select * from user_sys_privs; permission granted by lisi to any table of wangwu users: SQL grant alter any table to wangwu with admin option; authorization successful. View system permissions of wangwu users: SQL> select * from user_sys_privs; 2. Transfer object permissions (who owns and who authorizes them) create A Table A as an administrator: SQL> create table A (id int); the table has been created. Www.2cto.com grants the view permission of Table A to lisi: SQL> grant select on A to lisi with grant option; the authorization is successful. View lisi object permissions: SQL> select * from user_tab_privs; lisi users view sys. grant the permissions of Table A to the wangwu User: SQL> grant select on sys. A to wangwu; authorization successful. View wangwu object permissions: SQL> select * from user_tab_privs; Authorize wangwu users to view sys. table A permission: SQL> grant select on sys. A to wangwu with grant option; authorization successful. View wangwu object permissions at www.2cto.com: SQL> select * from user_tab_privs;