Oracle creates users, tablespaces, and empowers

--Create TABLE space

Create Tablespace Test_tps

DataFile ' D:\app\Administrator\oradata\orcl\test_tps.dbf '

Size 1500M

Autoextend on next 5M;

--Create a user and make a table space

Create user Test_tps identified by Test_tps

Default Tablespace Test_tps;

--Assigning permissions

Grant Connect,resource to Test_tps;

Grant create any sequence to Test_tps;

Grant create any table to Test_tps;

Grant Delete any table to Test_tps;

Grant insert any table to Test_tps;

Grant Select any table to Test_tps;

Grant unlimited tablespace to Test_tps;

Grant execute any procedure to Test_tps;

Grant update any table to Test_tps;

Grant create any view to Test_tps;

--Empowering DBAs

Grant SYSDBA to Test_tps;

--Revoke DBA Authority

Revoke DBA from user

---------------------------------------------------------------

--Authorization command:

--grant {dba| resource| CONNECT} to {public|user-list}

--public|user-list: All or a specified user.

-Three types of permissions and only one, do not execute the GRANT statement during transaction processing.

Oracle creates users, tablespaces, and empowers