Controlling User Permissions

Actions such as creating a role grant permission

1 Permissions

The security of database is divided into system security and data security.

System permissions are permissions on the database Permissions object permission is the permission to manipulate database objects

2 System Permissions

More than 100 effective permissions

The database administrator has advanced permissions to complete administrative tasks such as

Create a new user delete a user delete a table backup table

3 Creating a user

Create User username

Identified by password

4 After the user has been created, theDBA will give some permissions

Grant Create session

To user name

For example, application developers typically have the following system permissions

Create session Creation sessions

CREATE table creating tables

Create SEQUENCE Creating a sequence

CREATE View View

CREATE Procedure Process

5 Creating a user table space

In addition to the create table permission, the user also needs to allocate a table space to open up the tables that the storage space uses to create

Alter User username Quota Unlimited ( Unlimited values can also be limited)

On users ( table space)

6 users have permission to modify their own password

Alter User username

Identified by password

7 characters

Collection of permissions

Create a role

Create My_role

granting permissions

Grant Create Session,create table,create view to My_role

Grant a role to a user

Grant my_role to user name

8 Object Permissions

Different objects have different object permissions

The owner of the object has all permissions

The owner of the object can assign permissions outside the

9grant Select

On table name

To user name /public/role

A table for a user

Written as a user . Table name

11with Grant Option

If you add the WITH Grant option after the grant, the person you grant can continue to grant this permission to others

Revoke object Permissions

Revoke Object Permissions

On table name

From user name

Cascade constraints Cascade retract

Controlling User Permissions