Oracle - Controlling User Access, Creating and Revoking Object Privileges | Oracle Revoke Access
►Title:
Oracle - Controlling User Access, Creating and Revoking Object Privileges | ওরাকল - রিভোকিং
►Content:
Revoking User Privileges
=========================================
01. Connect to hr user
conn hr/hr
02. grant privilege to dba167 user
grant
select,insert, delete ,update
on employees
to dba167
with grant option
03. Connect dba167/123
select *
from hr.Employees;
04. Connect to sysdba
conn sys as sysdba
select username
from dba_users
05. create new user by sys user
create user a
identified by 123;
grant create session
to a;
06. Connect to dba167 and give privileges of employees table to a user
conn dba167/123
02. grant privilege to a user
grant
select,insert, delete ,update
on hr.employees
to a
07. Connect to a user
conn a/123;
select *
from hr.Employees;
08. Revoking privileges from user a by hr user
revoke select, insert, update,delete
on employees
from dba167;
🔗LINKS🔗
Website: http://rejawebs.com/#/
LinkedIn: / md-rezoyanul-islam-096a3775
►►► Find me on Social Media◄◄◄
Facebook: / 1145510332685812
✉ Contact with me
Email: mailto:[email protected]
❤ Make sure you SUBSCRIBE and be the 1st one to view newly created videos!