Question Locked

oracle

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

2 replies

by tony hopkinson

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.