469,270 Members | 1,026 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,270 developers. It's quick & easy.

How to give privileges of one user to another

After creating the user, how to give the new user the priviledges of Scott. I mean I want to use the tables of Scott
Oct 16 '07 #1
5 18143
amitpatel66
2,367 Expert 2GB
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>;
Oct 16 '07 #2
amitpatel66
2,367 Expert 2GB
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
Oct 16 '07 #3
gintsp
36
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
Oct 16 '07 #4
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>;
Oct 16 '07 #5
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
Oct 16 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Marc | last post: by
4 posts views Thread by Amardeep Verma | last post: by
reply views Thread by Charles Cantrell | last post: by
reply views Thread by Marc | last post: by
reply views Thread by Fred Johnson | last post: by
2 posts views Thread by virgilio | last post: by
4 posts views Thread by Feldman Alex | last post: by
6 posts views Thread by Frank Swarbrick | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.