Oracle Development: Create a user and assign table spaces and assign permissions

--Create a user and assign a tablespace and assign permissions--Log in sysdba [email protected]:~> sqlplus/as sysdbasql*plus:release 12.1.0.2.0 Production on Mon Mar 7 18:48:59 2016Copyright (c) 1982, Oracle.  All rights reserved. Connected to:oracle Database 12c Enterprise Edition Release 12.1.0.2.0-64bit productionwith The partitioning, OLAP, Adva nced Analytics and Real application testing optionssql>--Create a user ABC with a password of creditderivativecreate user ABC identified by CR editderivative--set Tablespace: Let users use the default tablespace usersdefault tablespace users--set tablespaces: Let users use temporary tablespace temptemporary tablespace temp--Default permissions: The initial definition of the resource does not limit the profile default--unlock: The default setting for Oracle is when the password is logged on the wrong number of times, the system automatically lock the user, at this time can use this command to unlock the account unlock;-- Assigning developer Rights Grant RESOURCE to abc;--assigns the typical rights of the end user, the most basic grant CONNECT to abc;--assigns the permission to create the view grant creation view to abc;-- Set the user's authorized role to the default role alter user ABC default role all;--The user can freely build tables in this tablespace grant UNLIMITED tablespace to abc;-- Assigning permissions to create materialized views grant create materialized view to ABC;

Oracle Development: Create a user and assign table spaces and assign permissions