Process of creating user permissions in Oracle

This article describes how to create user permissions in Oracle by creating a table. The following code is mainly written to implement the Oracle user creation permission.

This article describes how to create user permissions in Oracle by creating a table. The following code is mainly written to implement the Oracle user creation permission.

This article describes how to create user permissions in Oracle by creating a table. The following code is mainly used to compile the Oracle user creation permission, hoping to help you.

Note: Each language is executed separately and must end with a semicolon;

// Create tablespace test datafile 'C: \ oracle \ oradata \ orcl9 \ test. dbf 'size 50 M default storage (initial 500 K Next 500 K minextents 1 maxextents unlimited pctincrease 0 );

// Create user permission in Oracle // create user lxg identified by lxg default tablespace test; // authorize grant resource, connect, dba to test;

// Delete the tablespace drop tablespace "space name" including contents and datafiles

Delete a user

Drop user "lxg" cascade

Add tablespace

Alter tablespace chinawater add datafile 'C: \ oracle \ oradata \ orcl9 \ ADDCHINAWATER. dbf'size 200 M

Create user

Create user userName identified by password;

Create userName and password

2

Authorize a user

Grant dba to lxg; -- grant DBA permission grant unlimited tablespace to lxg; -- grant unlimited tablespace grant select any table to lxg; -- grant query to any table grant select any dictionary to lxg; -- Grant query to any dictionary

Grant dba to lxg; grant unlimited tablespace to lxg; grant select any table to lxg; grant select any dictionary to lxg;

,