Single Table authorization
Grant
Select,
Insert,
Update,
Delete
OnTable Name
ToAuthorized user name;
Grant
Select,
Insert,
Update,
Delete,
References,
Alter,
Index
OnT_fix_bind_route
ToSpos_user3;
All table authorization
Select'Grant select, insert, update, delete on' | T. tname | 'to authorized user name ;'
FromTab t
WhereT. tabtype = 'table ';
Single sequence authorization
Grant
Select
OnSequence name
ToAuthorized user name;
Grant
Select
OnNac_user.seq_l_tradelist_atuoid
ToSpos_user3;
Authorize a userAll sequences
Select'Grant select on' | T. sequence_name | 'to authorized user name ;'
FromSYS. dba_sequences t
WhereSequence_owner = 'authorization username (uppercase )';
Stored Procedure authorization
Grant
Execute
OnNac_posp
ToSpos_user3;
Grant debugging permissions to users
Grant
Debug
Session
ToUser Name
DBA revokes Permissions
Select'Revoke all on web_user. '| T. object_name |' from nac_user ;'
FromDba_objects t
WhereT. Owner = 'web _ user'
AndT. object_type
In('Table', 'sequence ', 'view', 'Procedure') -- Object Type
About grant authorization
