Oracle creates a normal user and gives permissions

Oracle creates a normal user and gives permissions

1) using SYS or system/manager as SYSDBA; Connect to the database.

2) Create peng:create user Peng identified by pwd_oracle;

Delete users, drop user peng;

3) grant the user permission to log on to the database: Grant create session to Peng;

4) grant the user permission to manipulate the table space:

Grant unlimited tablespace to Peng;

Grant create tablespace to Peng;

Grant alter TABLESPACE to Peng;

Grant drop tablespace to Peng;

Grant manage tablespace to Peng;

5) grant permissions to the User action table:

Grant CREATE table to Peng; (Contains the CREATE INDEX permission, ALTER TABLE, DROP TABLE permission)

6) grant permissions to the user operation view:

Grant CREATE view to Peng; (includes ALTER view, DROP VIEW permission)

7) grant permissions to user action triggers:

Grant create trigger to Peng; (Contains ALTER TRIGGER, DROP TRIGGER permissions)

8) grant the user permission to manipulate the stored procedure:

Grant CREATE procedure to Peng; (includes alter procedure, drop procedure and function, and package permissions)

9) grant permissions to the user action sequence:

Grant create sequence to Peng; (includes creation, modification, deletion, and selection sequence)

10) grant the user fallback segment permission:

Grant Create rollback segment to Peng;

Grant alter rollback segment to Peng;

Grant drop rollback segment to Peng;

11) Grant the user synonym permissions:

Grant create synonym to Peng; (including drop synonym permissions)

Grant create public synonym to Peng;

Grant drop public synonym to Peng;

12) grant the user permissions about the user:

Grant create user to Peng;

Grant alter user to Peng;

Grant become user to Peng;

Grant drop user to Peng;

13) Grant the user permissions on the role:

Grant create role to Peng;

14) Grant user permission to manipulate profiles

Grant create profile to Peng;

Grant alter profile to Peng;

Grant drop profile to Peng;

15) allows selection from a data dictionary table owned by the SYS user

Grant Select any dictionary to Peng;

This article is from a "a little" blog, make sure to keep this source http://pengai.blog.51cto.com/6326789/1976439

Oracle creates a normal user and gives permissions