Oracle User Rights Assignment Description

In general, it is not recommended to assign DBA authority after an Oracle normal user is created. So what permissions are generally assigned?

First of all, an Oracle general user, our general requirements are:

1. Be able to create the table structure, data maintenance under this user's related.

2. Ability to access other users ' tables (see System Properties).

Therefore, the following statements are generally used:

Grant Connect,resource to base;//set control permissions on the local resource, grant create session to base;//setting can access the user grant Select any table to B through the tool    ase;//settings can access other user tables grant Select any sequence to base;//settings can access other users ' indexes

Problem:

Many people will run the following SQL, that need not?

Grant CREATE TABLE     to    base;grant create sequence  to    base;grant CREATE procedure to    base;grant  Select any table to    base;grant Select any sequence to base;grant inserts any table,update any table,delete any table to Base

After the experiment, it should not be necessary.

After executing standard SQL, query via sql: SELECT * from Session_privs;

As you can see, you already have create-related permissions.

Oracle User Rights Assignment Description