Re: grant ... as user

Yes, my "grant as" was a way to avoid using the system cataloge and asking the privileges from there. I tried to keep independent of different systems. This was not the real way because "grant as" is not available on different systems. So I should query the system cataloge. I have now found the orace system catologe documentation on the web. I'll do it this way. Thanks for your help.

On 01 Mai 2001, you wrote in comp.databases.oracle.misc:

>Thomas Vatter wrote:
>
>> in informix i had made a check if a user has database access. I used
>> "grant something on sometable as user"
>> to see if this user has been granted access on database-tables before.
>> in oracle there is no "as user" clause. Is there another easy way to
>> check if a user has database-table access in oracle?
>
>In Oracle you can pretty much find out anything you want in the data
>dictionary tables and views. I would strongly urge you to learn how to
>use it.
>
>In this case try a SELECT from dba_tab_privs
>
>How to use the data dictionary is one of the first things I teach my
>students.
>
>Daniel A. Morgan
>
>
Received on Tue May 01 2001 - 05:17:20 CDT