Oracle user and permission allocation

Oracle user and permission assignment SQL code -- log on to the database through the console: sqlplus kely/kely @ ORCL_localhost -- user set: dba_users select * from dba_users; -- use the system user to create a new user -- create user username identified by password default tablespace; -- system user: system and sys: sys (sysdba database administrator, highest database user; system database operator permission only in sys) -- get system permission information desc dba_sys_privs; -- query the system permission of a specified user select * from dba_sys_privs where lower (grantee) = 'kely '; -- Query System permission information desc system_privilege_map; select * from system_privilege_map; -- assign system permission -- grant privilege (permission) to username; with admin option -- indicates that once a user obtains the permission to be assigned, then these permissions can be propagated-revoke the user's permission revoke privilege (permission) from user -- Object permission select, insert, update, delete, execute, index, references, alter (all use all) --- assign permission grant permission on Object (table) to user with grant option; -- propagation -- revoke permission revoke object permission on object from user; -- Role