Oracle initial role assignment

-- Create a tablespace

Create tablespace qebcp datafile 'C: \ Oracle \ QebCP \ qebcp. ora'

Size 100 m reuse default storage (initial 500 k next 500 k pctincrease 20 );

-- Create a table user

Create user qebcp identified by buzhidao default tablespace qebcp quota 10 m on users;

-- Assign Permissions

Grant connect, resource, dba to qebcp;

-- Query all Permissions

Select * from DBA_TAB_PRIVS;

-- Query the permissions granted to the user

Select * from USER_SYS_PRIVS;

-- Display all roles granted to the user

Select * from USER_ROLE_PRIVS;