Grant Oracle user to access oracle table

We can grant all oracle objects from one user to another user by below package

CREATE OR REPLACE PROCEDURE GRANT_ORACLE_TABLES(FROM_USER VARCHAR2,TO_USER VARCHAR2)
IS
BEGIN

FOR tab IN (SELECT table_name
FROM   all_tables
WHERE  owner = FROM_USER) LOOP
EXECUTE IMMEDIATE ‘GRANT ALL ON ‘||tab.table_name||’ TO ‘||TO_USER;
END LOOP;
END;

If you want to grant only one objects at a time you can use below statment

GRANT ALL ON <TABLE NAME> TO <USER NAME>;

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: