How to give privileges of one user to another

[Latha R]

After creating the user, how to give the new user the priviledges of Scott. I mean I want to use the tables of Scott

[amitpatel66]

After creating the user, how to give the new user the priviledges of Scott. I mean I want to use the tables of Scott

GRANT SELECT on the tables that you want to use from scott.

Eg:

Connect to SCOTT:

GRANT SELECT ON EMP TO <new_user>;

[amitpatel66]

you can use

GRANT ALL PRIVILEGES [(column, column,...)]
ON [schema.]object
TO grantee [WITH GRANT OPTION] [WITH HIERARCHY OPTION]

Check for more GRANT options here

[gintsp]

AS Scott:

GRANT <necessary privileges> ON <necessary objects> TO <new_user>;

For easier use as new user:

CREATE SYNONYM <synonym name> FOR SCOTT.<necessary objects>;

See GRANT synatx and available object privileges here
Table 18-3 Object Privileges Available for Particular Objects

Create synonym syntax here


Gints Plivna
http://www.gplivna.eu

[Latha R]

Thank you very much Amit

[With regards,
Latha R

GRANT SELECT on the tables that you want to use from scott.

Eg:

Connect to SCOTT:

GRANT SELECT ON EMP TO <new_user>;

[Latha R]

Thank you very muh,

With regards,
Latha

AS Scott:

GRANT <necessary privileges> ON <necessary objects> TO <new_user>;

For easier use as new user:

CREATE SYNONYM <synonym name> FOR SCOTT.<necessary objects>;

See GRANT synatx and available object privileges here
Table 18-3 Object Privileges Available for Particular Objects

Create synonym syntax here


Gints Plivna
http://www.gplivna.eu