Oracle gives users a variety of permissions, only as a normal user

• Using the SYS or System/manager as SYSDBA; Connect to the database.
• Create a regular user konglin:create users konglin identified by Pwd_oracle;

Delete users, drop user Konglin;

• Grant user permission to log on to the database: Grant create session to Konglin;
• To grant the user the right to manipulate the table space:

Grant unlimited tablespace to Konglin;

Grant create tablespace to Konglin;

Grant Alter TABLESPACE to Konglin;

Grant drop tablespace to Konglin;

Grant manage tablespace to Konglin;

• Permissions granted to user action tables:

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

• To grant permissions to the user operation view:

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

• Permissions granted to user action triggers:

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

• To grant users permission to manipulate stored procedures:

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

• Permissions granted to the user action sequence:

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

• To grant a user fallback segment permission:

Grant Create rollback segment to Konglin;

Grant alter rollback segment to Konglin;

Grant drop rollback segment to Konglin;

• To grant a user synonym permission:

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

Grant create public synonym to Konglin;

Grant drop public synonym to Konglin;

• To grant users permissions about a user:

Grant create user to Konglin;

Grant alter user to Konglin;

Grant become user to Konglin;

Grant drop user to Konglin;

• To grant a user permissions on a role:

Grant create role to Konglin;

• Permissions granted to the user to manipulate the profile

Grant create profile to Konglin;

Grant alter profile to Konglin;

Grant drop profile to Konglin;

• Allows selection from a data dictionary table owned by the SYS user

Grant Select any dictionary to Konglin;

Create user Wzl identified by 123;

Grant connect to Wzl;

Grant resource to Wzl;

Grant CREATE table to Wzl;

Grant CREATE view to Wzl;

Grant create trigger to WZL;

Grant CREATE procedure to WZL;

Grant create sequence to Wzl;

Grant Create rollback segment to WZL;

Grant alter rollback segment to WZL;

Grant drop rollback segment to WZL;

Grant create synonym to Wzl;

Grant create public synonym to Wzl;

Grant drop public synonym to Wzl;

Grant create user to Wzl;

Grant alter user to WZL;

Grant become user to Wzl;

Grant drop user to Wzl;

Grant create role to WZL;

Grant create profile to Wzl;

Grant alter profile to WZL;

Grant drop profile to Wzl;

Grant Select any dictionary to Wzl;

Oracle gives users a variety of permissions, only as a normal user