Oracle creates a user and grants the user permission to query the specified table or view

MSV31 Account Login database to do the following:

CREATE USER NORTHBOUND identified by NORTHBOUND
DEFAULT tablespace "Tbs_dninmsv31"
Temporary tablespace "TEMP2"
QUOTA UNLIMITED on "tbs_dninmsv31";

GRANT "CONNECT" to NORTHBOUND;
ALTER USER NORTHBOUND DEFAULT ROLE NONE;

GRANT CREATE SESSION to NORTHBOUND;

GRANT SELECT on "DNINMSV31". " V_dndevice "toNORTHBOUND;
GRANT SELECT on "DNINMSV31". " V_dnsubne "to NORTHBOUND;
GRANT SELECT on "DNINMSV31". " V_dnpackage "to NORTHBOUND;
GRANT SELECT on "DNINMSV31". " V_dnport "to NORTHBOUND;

Note: When querying with northbound log in, add DNINMSV31 to the view before the report or view does not exist.
For example:
SELECT * FROM DNINMSV31.     V_dndevice; --Can execute normally

SELECT * FROM DNINMSV31.   Tb_device where rownum<5; --The report or view does not exist when executing

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

GRANT Debug any procedure, debug connect session to HNCKB;
Grant SELECT on Sys.dba_pending_transactions to HNCKB;
Grant CREATE view,create job,create synonym to hnckb;
Grant Connect,resource to hnckb;
1. Standard roles
CONNECT
RESOURCE

2. System permissions
CREATE VIEW
CREATE DATABASE LINK
CREATE JOB
CREATE synonym
UNLIMITED tablespace
Change quotas
Command: ALTER USER name QUOTA 0 on table space name
ALTER USER name QUOTA (value) k| m| UNLIMITED on table space name;
How to use:
A. Control user Data growth
B, when the user has a certain amount of data, and the administrator does not want him to add new data.
C, when the user quota is set to zero, the user cannot create new data, but the original data can still be accessed.

3. Object permissions
Dba_pending_transactions (SELECT)-XA transaction support

Grant SELECT on Sys.dba_pending_transactions to user;
4. Proposed Open
Debug CONNECT session-Debugging stored Procedures
For example:
GRANT Debug any procedure, debug connect session to HR;

Oracle creates table spaces, creates users, grants, access to authorized objects, and view permissions
1. Create a temporary table space
The Oracle temp table space is used primarily for querying and storing some buffer data. The primary reason for the temporary tablespace consumption is that the intermediate junction of the query needs to be

To sort the results.
The primary role of temporal tablespace:
index Create or rebuild
Order by or GROUP by
Distinct operation
Union or intersect or minus
Sort-merge joins

CREATE temporary tablespace "Test_temp"
Tempfile ' D:oracleproduct10.2.0oradatagistest_data.ora '
SIZE 20M
Autoextend on
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;

2. Create a user table space
CREATE tablespace "Test_data"
LOGGING
DataFile ' D:oracleproduct10.2.0oradatagistest_data.ora '
SIZE 20M
Autoextend on
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;

3. Create a user and set its tablespace
Username:usertest
Password:userpwd

CREATE USER Usertest identified by userpwd
DEFAULT tablespace Test_data
Temporary tablespace test_temp;

4. Authorization to the user
GRANT
Create SESSION, create any TABLE, create any VIEW, create any INDEX, create any PROCEDURE,
Alter any TABLE, alter any PROCEDURE,
Drop any TABLE, drop no VIEW, drop any INDEX, drop any PROCEDURE,
SELECT any table, INSERT any table, UPDATE all table, DELETE any table
to username;

First authorize users to testuser two basic role permissions

Connect Role: – is the typical right to grant the end user the most basic
Create session– session

Resource role: – is granted to developers
Create cluster– Build Cluster
Create procedure– Setup process
Create sequence– Build Sequence
Create table– Build Table
Create trigger– CREATE Trigger
Create type– Build Type
Create operator– created by operator
Create indextype– Creating an index type
Create table– creating a table

The SQL statement that authorizes the role to the user:
GRANT role to username;

5. View User Permissions

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;

Create Tablespace-Create user-authorization

Create tablespace HRM datafile ' D:\oracle\product\10.1.0\oradata\orcl\hrm.dbf ' size 100M autoextend on;
Create user Frankdun identified by Frankdun default tablespace HRM temporary tablespace temp;
Grant Resource,connect,debug connect session to Frankdun;

Oracle creates a user and grants the user permission to query the specified table or view