Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Insufficient Privliges even after sufficient grants

Re: Insufficient Privliges even after sufficient grants

From: Erik <napel25_at_hotmail.com>
Date: Thu, 16 Dec 1999 11:15:08 +0100
Message-ID: <83ae27$489$1@porthos.nl.uu.net>


I had a problem like that.
I did give permissions to a role and give the role to a user. The access was denied.
When i did give the permissions direct to the user, the problem was solved.

Erik

Chuck wrote in message <3857d4e9.176901581_at_client.nw.news.psi.net>...
>
>I have a large ERP implementation that resides in a schema with DBA
>privilege. (Not with admin option) This schema consists of about 4100
>objects, 1200 of them being tables.
>
>I wrote a script to grant update, insert, delete, and select privleges
>on all tables in this shema to another user. However, this user is
>still unable to update rows in any tables.
>
>When I executed the script, as the ERP schema owner, all grants
>succeeded.
>
>The user I am granting them to has connect, and resource permissions.
>
>What am I missing?
>
>
>Thanks,
>Chuck
>
Received on Thu Dec 16 1999 - 04:15:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US