How To Grant SELECT Object Privilege On One or More Tables to a User | Oracle 11g | SQL Developer
In this video, I'll show you How To Grant SELECT Object Privilege On One or More Tables to a User in Oracle database 11g using SQL Developer.
Procedure Code:
CREATE OR REPLACE PROCEDURE GRANT_SELECT(
USERNAME VARCHAR2,
GRANTEE VARCHAR2
)
AS
BEGIN
FOR r IN (SELECT TABLE_NAME, OWNER FROM ALL_TABLES
WHERE OWNER = USERNAME)
LOOP
EXECUTE IMMEDIATE
'GRANT SELECT ON ' || r.OWNER || '.' || r.TABLE_NAME || ' TO ' || GRANTEE;
END LOOP;
END;
Contact:
For More Videos,
Please Subscribe my Channel:
/ @mohammadzohaibsplixed
Website:
http://mohammadzohaibsplixed.blogspot...
Emails:
[email protected]
[email protected]
Facebook:
/ splixed (Profile)
/ mohammadzohaibsplixed (Page)
Twitter:
/ mr_zobi
Skype:
mohammadzohaibsplixed
#Oracle11g
#OracleCreateUser
#GrantSelectObjectPrivilege
#SqlDeveloper
#Database
#Splixed
How To Grant SELECT Object Privilege On One or More Tables to a User
how to create a user in oracle 10g
oracle create user sql developer
users in oracle database
how to create user in oracle 11g
how to create user in oracle sql developer
how to create user in oracle database
how to create new user account in oracle database
oracle create user
pl/sql procedure
Grant SELECT on all tables in a schema to a user
Grant SELECT on a table to a user
oracle
database
splixed