Re: Privlage problem

EIU#120150 LUM 034 LAB wrote:
>
> I am trying to grant a user the privlage to view any of an owner's
> tables. Current the owner has no tables.
> Usually the syntax is as follows:
> GRANT (privlage) ON (table) TO (user);
> But since the owner has no tables as of yet, I do not know what to put
> in the table part of the command.
> Can anyone help me?
> By the way, I am a student but I am not cheating. I am working for a
> professor as the DBA for his Dbase class.
> --thanks!

grant select any table to xyz;

This lets xyz view any table owned by ANY user

-- 
Connor McDonald
Systems Administrator-Unix/Oracle
BHP Iron Ore
"You're not drunk if you can lie on the floor without holding on"
            - Dean Martin