Oracle Create User

Create a temporary table space

CREATE Temporary  'C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf'on  NEXT  32M MAXSIZE 2048MEXTENT MANAGEMENT LOCAL;

Create a user table space

CREATE'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\TEST_DATA01. DBF'onNEXT  32M MAXSIZE 2048MEXTENT MANAGEMENT LOCAL;

Create a user and make a table space

CREATE USER  by Password DEFAULT tablespace test_data Temporary Tablespace test_temp;

Granting permissions to Users

GRANT  　　 CREATESESSION,CREATE  any TABLE,CREATE  any VIEW,CREATE  any INDEX,CREATE  any PROCEDURE,ALTER  any TABLE,ALTER  any PROCEDURE,DROP  any TABLE,DROP  any VIEW,DROP  any INDEX,DROP  any PROCEDURE,SELECT  any TABLE,INSERT  any TABLE,UPDATE  any TABLE,DELETE  any TABLE 　　  toUsername

Delegating role to username, that is, enabling username this user to manage and use the resources owned by role

GRANT  to username;

View All Users

SELECT *  from dba_users; SELECT *  from all_users; SELECT *  from User_users;

View User system permissions

SELECT *  from Dba_sys_privs; SELECT *  from User_sys_privs;

View user object or role permissions

SELECT *  from Dba_tab_privs; SELECT *  from All_tab_privs; SELECT *  from User_tab_privs;

View all roles

SELECT *  from Dba_roles;

To view the roles owned by a user or role

SELECT *  from Dba_role_privs; SELECT *  from User_role_privs;

-- -----encountered no privileges on tablespace ' tablespace ' Alter user UserQuota 10M[unlimited] on tablespace;

Oracle Create user