Oracle tablespace and user-created

-------------------------CREATE table spaces with users

Create a temporary table space

create temporary tablespace test_temp
650) this.width=650 ; "src=" Http://www.blogjava.net/Images/OutliningIndicators/None.gif "/> Tempfile '/u01/oracle/product/10.2.0/oradata/orcl/test_temp01.dbf '
650) this.width=650; "src=" Http://www.blogjava.net/Images/OutliningIndicators/None.gif "/> Autoextend on
650) this.width=650; "src=" http://www.blogjava.net/Images/OutliningIndicators/None.gif "/ > NEXT 32M MAXSIZE 2048M
650) this.width=650; "src="/HTTP/ Www.blogjava.net/Images/OutliningIndicators/None.gif "/>

Create a user table space

CREATE tablespace Test_data
650) this.width=650; "src=" Http://www.blogjava.net/Images/OutliningIndicators/None.gif "/>LOGGING
650) this.width=650; "src=" Http://www.blogjava.net/Images/OutliningIndicators/None.gif "/>datafile '/u01/oracle/product/10.2.0/oradata/orcl/my_data01.dbf '
650) this.width=650; "src=" Http://www.blogjava.net/Images/OutliningIndicators/None.gif "/>SIZE 32M
650) this.width=650; "src=" Http://www.blogjava.net/Images/OutliningIndicators/None.gif "/>Autoextend on
650) this.width=650; "src=" Http://www.blogjava.net/Images/OutliningIndicators/None.gif "/>NEXT 32M MAXSIZE 2048M
650) this.width=650; "src=" Http://www.blogjava.net/Images/OutliningIndicators/None.gif "/>EXTENT MANAGEMENT LOCAL;

Create a user and make a table space

CREATE USER username identified by password
DEFAULT tablespace Test_data
Temporary tablespace test_temp;

--------------------user empowerment and viewing user rights

Granting permissions to Users

GRANT
650) this.width=650; "src=" Http://www.blogjava.net/Images/OutliningIndicators/None.gif "/>Create SESSION, create any TABLE, create any VIEW, create any INDEX, create any PROCEDURE,
650) this.width=650; "src=" Http://www.blogjava.net/Images/OutliningIndicators/None.gif "/>ALTER any TABLE, alter any PROCEDURE,
650) this.width=650; "src=" Http://www.blogjava.net/Images/OutliningIndicators/None.gif "/>drop any TABLE, drop no VIEW, drop any INDEX, drop any PROCEDURE,
650) this.width=650; "src=" Http://www.blogjava.net/Images/OutliningIndicators/None.gif "/>SELECT any table, INSERT any table, UPDATE all table, DELETE any table
650) this.width=650; "src=" Http://www.blogjava.net/Images/OutliningIndicators/None.gif "/>to username;

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

650) this.width=650; "src=" Http://www.blogjava.net/Images/OutliningIndicators/None.gif "/>GRANT role 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; 650) this.width=650; "src=" Http://www.blogjava.net/Images/OutliningIndicators/None.gif "/>

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;

This article is from the "strive to the front" blog, please be sure to keep this source http://liucb.blog.51cto.com/3230681/1582387

Oracle tablespace and user-created