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..


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

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.


Related Discussions

Related Forums