Re: Object privileges question

Objects created as user SYS are likely to end up housed in the SYSTEM tablespace. That's a big, big no-no.

Objects created as user SYS are also never able to be exported. That's a royal pain in the butt waiting to get you.

Use SYS for performing privileged actions (startup, shutdown, backup, recover, create database), *and for nothing else*.

As for the issue about username.tablename -you can create synonyms to get around the problem (but Steve Adams reports performance problems if there's a proliferation of synonyms). Otherwise, live with it: at the end of the day, every object in Oracle is ultimately referenced by schema and username -even if you use synonyms to hide the fact from your users.

Regards
HJR "Jordan" <mj_at_nba.com> wrote in message
news:9nijjq$se36_at_imsp212.netvigator.com...
> Dear all,
>
> I have used "sys" account to create a table, called "emp".
> However, when one of the user called "john" want to select data from that
> table, messages "ORA-04043: object emp does not exist". I have already
> granted ALL rights to john, it doesn't work. But, when john type "select
*
> from sys.emp;", it works. I want that john need not to type the owner in
> front of the table when each time he wants to access other tables. How
can
> I do so? THANKS.
>
> Best Regards,
> Jordan
>
>
Received on Mon Sep 10 2001 - 14:53:52 CDT