Oracle role permission management

Welcome to the Oracle community forum and interact with 2 million technical staff to enter ------- permission management: Object revocation authorization grantselectmytabletoleap2grantallonmytabletoleap2 ----- permission management: Permission transfer --- permission transfer not allowed grantalteranytabletoleap2 --- change the table structure

Welcome to the Oracle Community Forum, interact with 2 million technical staff> go to ------- permission management: grant select mytable to leap2 grant all on mytable to leap2 ----- permission management: transfer permissions --- you cannot pass the grant alter any table to leap2 --- modify

Welcome to the Oracle community forum and interact with 2 million technical staff> enter

　　------- Permission management: revoking authorization on an object

Grant select mytable to leap2

Grant all on mytable to leap2

　　----- Permission management: transfer of Permissions

--- The permission cannot be transferred

Grant alter any table to leap2 --- grant leap2 the permission to modify the table structure,

Leap2 cannot grant this permission to another user leap3.

--- Permission Transfer

Grant alter any table to leap2 with admin option --- authorize leap2 to modify the table structure,

Leap2 can grant this permission to other users leap3.

----- Granting the Table query permission to other users cannot be passed

Grant select on mytable to leap2 --- grant the permission to query tables to leap2,

Leap2 cannot grant this permission to another user leap3.

--- Grant the Table query permission to other users

Grant select on mytable to leap2 with grant option --- grant the permission to query the table to leap2,

Leap2 can grant this permission to other users leap3.

　　---- A role is a set of permissions. You can grant a role to the user.

--- Create a role

Create role myrole

--- Delete a role

Drop myrole

-- A role is a set of permissions, so you must put the permissions in the role.

Grant create session to myrole

Grant create table to myrole

--- Authorize a role to the user

Grant myrole to leap

Note: Some permissions cannot be authorized to the role.

For example, unlimited tablespace

Indicates that

Roles are not shared by any user.

--- Restrict users

Alter User Username Account Lock ---- User Lock

Alter User Username Account unLock ---- unLock User

Alter User Username Password expire ---- the User Password becomes invalid

--- Delete a user

Drop User Username --- every object under a User

Drop User Username cascade ---- tables or objects under the User must use cascade

Cascade indicates that all objects of the user are forcibly deleted.

　　---- Start oracle listener under the command

Lsnrctl start [listenerName] -- start

Lsnrctl stop [listenerName] -- disable

We hope this list will help Oracle system administrators.

[1] [2]