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.
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.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
oracle
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