Re: Insufficient Privliges even after sufficient grants

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