How To Grant SELECT Object Privilege On One or More Tables to a User | Oracle 11g | SQL Developer

Опубликовано: 01 Январь 1970
на канале: Mohammad Zohaib Splixed

11,632

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

Смотрите видео How To Grant SELECT Object Privilege On One or More Tables to a User | Oracle 11g | SQL Developer онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Mohammad Zohaib Splixed 01 Январь 1970, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 11,632 раз и оно понравилось 74 людям.