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 30 Apr 2001, you wrote in comp.databases.oracle.server:

>
>"Thomas Vatter" <thomas.vatter_at_blinx.de> wrote in message
>news:Xns9093DF954C03Fthomasvatter_at_192.168.115.1...
>> 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?
>
>First of all: try to avoid posting identical messages to various groups.
>There's no need for that, you don't get a bigger audience. Also, if you
>really think you need multiple groups, crosspost, so that at least
>everyone in those groups sees any answer. I usually check answers before
>I answer myself, and if a question already has been answered, I don't
>bother to answer it again.
>Needless to say, when people duplicate their posts to multiple groups, I
>don't see the responses and am wasting my time.
>
>I'm not sure where you are hinting at?
>Do you want to know whether an user has access to a particular table
>before you select from it?
>In that case, you can check the all_tables view, which shows all tables
>the user has access too.
>Also in Oracle a duplicate grant is always successful: if the grant
>already exists, you won't get an error message.
>And the only way to grant 'on behalf of' occurs when the owner has
>granted you privilege 'with admin option'. Even sys can't grant on
>behalf of other users, if he doesn't have privilege himself.
>If this answer doesn't help you , please try to clarify your needs.
>
>Regards,
>
>Sybrand Bakker, Oracle DBA
>
>
>
>
  Received on Tue May 01 2001 - 05:11:41 CDT