oracle
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
IT Employment
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
by mihir.m Accepted solution
by tony hopkinson Accepted solution
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
This discussion is closed to new replies.
Sort by Trending