CREATE USER FZAFAR IDENTIFIED BY VALUES ’2BC657B017E6006B’ DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; — 5 Roles for ITSM GRANT SELECT_CATALOG_ROLE TO FZAFAR; GRANT EXECUTE_CATALOG_ROLE TO FZAFAR; GRANT DELETE_CATALOG_ROLE TO FZAFAR; GRANT RESOURCE TO FZAFAR; GRANT CONNECT TO FZAFAR; ALTER [...]
Archive for the ‘Users’ Category
13 May
Dropping User
To drop a user you must have the DROP USER system privilege To check if user has privilege to drop user. select * from session_privs where privilege=’DROP USER’; Dropping User without having objects: SQL> drop user test; SQL> drop user a cascade; Dropping a Connected User Find out the connected user sid and [...]
