How to create ordinary users and grant permissions to Oracle

This article is about how Oracle creates ordinary users and gives them permissions. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Oracle creates ordinary users and gives them permissions

1) use sys or system / manager as sysdba; to connect to the database.

2) create an ordinary user peng: create user peng identified by pwd_oracle

Delete user, drop user peng

3) Grant the user permission to log in to the database: grant create session to peng

4) Grant the user permission to manipulate the tablespace:

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 the user permission to manipulate the table:

Grant create table to peng; (including create index permission, alter table permission, drop table permission)

6) Grant the user permission to manipulate the view:

Grant create view to peng; (including alter view, drop view permissions)

7) Grant the user the right to operate the trigger:

Grant create trigger to peng; (including alter trigger, drop trigger permissions)

8) Grant the user permission to operate the stored procedure:

Grant create procedure to peng; (including alter procedure, drop procedure and function, and package permissions)

9) Grant the user permission to operate the sequence:

Grant create sequence to peng; (including create, modify, delete, and select sequences)

10) Grant the user the permission to return the segment:

Grant create rollback segment to peng

Grant alter rollback segment to peng

Grant drop rollback segment to peng

11) Grant synonym permissions to users:

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 on 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 the user permission to operate the profile

Grant create profile to peng

Grant alter profile to peng

Grant drop profile to peng

15) allow selection from data dictionary tables owned by sys users

Grant select any dictionary to peng

Thank you for reading! This is the end of the article on "how to create ordinary users and grant permissions to Oracle". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!