IT Employment

Question

Gravatar
Locked

oracle

By mihir.m ·
how to access a database table from a different user?
e.g the user scott has emp table. i have created my own user named as mihir.
so i want to access that emp table from my user.
i have tried a lot but i can not..

regards
Mihir

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
+ Follow this Discussion ·
| Thread display: Collapse - | Expand +

All Answers

gravatar
Collapse -

Scott has to grant you permission

by Tony Hopkinson In reply to oracle

to it.

As Scott (or sa)

GRANT Select, References On emp To Mihir

or some such. If you look up grant and revoke you'll get it. If you use Toad or such like you wade through a few menus and tick some boxes.

PS references is for lookups, you don't have to grant it, but I can't think of a situation where you woul grant select and not references, so I tend to do it at the same time.

HtHs

Back to IT Employment Forum
1 total post (Page 1 of 1)  

Start or search

Related Discussions

Related Forums