run SQL*PLUS, logon with user B, use command grant with the following guide :Use the GRANT command to grant both system and object privileges to a user account. Privileges can also be granted to roles. The syntax to grant privileges is GRANT privilege TO [user, role, PUBLIC] [WITH ADMIN OPTION] Around 100 system privileges exist in Oracle8, which can be listed by querying the SYSTEM_PRIVILEGE_MAP data dictionary view. A sample of frequently used system privileges is shown in Table 8.1. Many of the DROP privileges have corresponding ALTER and CREATE privileges, such as CREATE ANY INDEX. System Privilege Capability to?/td> ANALYZE ANY Analyze any table of any user account BECOME USER Connect to the database as another user without knowing their password DELETE ANY TABLE Delete records from any table of any user account DROP ANY CLUSTER Drop any cluster from any user account DROP ANY INDEX Drop any index from any user account DROP ANY PROCEDURE Drop any procedure of any user account DROP ANY ROLE Drop any role from the database (be careful not to drop default roles) DROP ANY SEQUENCE Drop any sequence from any user account DROP ANY SNAPSHOT Drop any snapshot (and snapshot log) from any user account DROP ANY SYNONYM Drop any synonym from any user account DROP ANY TABLE Drop any table from any user account (be careful not to drop data dictionary tables) DROP ANY TRIGGER Drop any trigger from any user account DROP ANY TYPE Drop any object type from any user account DROP ANY VIEW Drop any view from any user account (be careful not to drop data dictionary views) DROP PROFILE Drop any profile DROP PUBLIC DATABASE LINK Drop any public database link DROP PUBLIC SYNONYM Drop any public synonym DROP ROLLBACK SEGMENT Drop any rollback segment DROP TABLESPACE Drop any tablespace (be VERY careful when giving this privilege out) DROP USER Drop any user EXECUTE ANY PROCEDURE Execute any procedure of any user account EXECUTE ANY TYPE Execute any object type GRANT ANY PRIVILEGE Grant any system privilege to any user, including DBA GRANT ANY ROLE Grant any role to any user account INSERT ANY TABLE Insert records into any table of any user account LOCK ANY TABLE Explicitly lock any table of any user account (having more users that have this privilege increases the chances of lock contention) MANAGE TABLESPACE Take tablespaces online/offline, and do tablespace hot backups SELECT ANY SEQUENCE Increment any sequence of any user account, or see the current value SELECT ANY TABLE Select data from any table of any user account SYSDBA Have full DBA privileges, which includes all system privileges previously listed SYSOPER Have instance capabilities such as database startup and shutdown
ANALYZE ANY Analyze any table of any user account
BECOME USER Connect to the database as another user without knowing their password
DELETE ANY TABLE Delete records from any table of any user account
DROP ANY CLUSTER Drop any cluster from any user account
DROP ANY INDEX Drop any index from any user account
DROP ANY PROCEDURE Drop any procedure of any user account
DROP ANY ROLE Drop any role from the database (be careful not to drop default roles)
DROP ANY SEQUENCE Drop any sequence from any user account
DROP ANY SNAPSHOT Drop any snapshot (and snapshot log) from any user account
DROP ANY SYNONYM Drop any synonym from any user account
DROP ANY TABLE Drop any table from any user account (be careful not to drop data dictionary tables)
DROP ANY TRIGGER Drop any trigger from any user account
DROP ANY TYPE Drop any object type from any user account
DROP ANY VIEW Drop any view from any user account (be careful not to drop data dictionary views)
DROP PROFILE Drop any profile
DROP PUBLIC DATABASE LINK Drop any public database link
DROP PUBLIC SYNONYM Drop any public synonym
DROP ROLLBACK SEGMENT Drop any rollback segment
DROP TABLESPACE Drop any tablespace (be VERY careful when giving this privilege out)
DROP USER Drop any user
EXECUTE ANY PROCEDURE Execute any procedure of any user account
EXECUTE ANY TYPE Execute any object type
GRANT ANY PRIVILEGE Grant any system privilege to any user, including DBA
GRANT ANY ROLE Grant any role to any user account
INSERT ANY TABLE Insert records into any table of any user account
LOCK ANY TABLE Explicitly lock any table of any user account (having more users that have this privilege increases the chances of lock contention)
MANAGE TABLESPACE Take tablespaces online/offline, and do tablespace hot backups
SELECT ANY SEQUENCE Increment any sequence of any user account, or see the current value
SELECT ANY TABLE Select data from any table of any user account
SYSDBA Have full DBA privileges, which includes all system privileges previously listed
SYSOPER Have instance capabilities such as database startup and shutdown