Re: Adding a hidden column to a table and hidden tables in Oracle

If the system admin had the rights to see the table then he has rights to see the table. There are some special privileges in 91 for the sys and system users.
Jim

--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"tolga toonja" <tolgatoonja_at_yahoo.com> wrote in message
news:857fe98f.0301100633.42c3e991_at_posting.google.com...


> Thank you for the help.

> But I wonder;

> I want to hide the tables or views to the admin or system user. When I

> say hidden, I mean hiding a table name in the database->schema tree in

> Oracle DBA Studio, I don't mean inaccessable to the other users. If

> admin user knows the table, view or column name he or she can access

> them.

> I don't see some of the oracle tables in the database->schema tree in

> Oracle DBA Studio. I check them with the select query if I know it's

> name. can I do it for my tables or views. If so I can accomplish to

> hide the columns with hidden views.

> Honestly I want to have some hidden tables and columns in the

> database.

>

> thank you again for your help.

>

> configuration win200,oracle9i.