Re: User Priviliges
From: Tim McConechy <tmcconec_at_wie.com>
Date: 1997/10/27
Message-ID: <34550FE3.C73C0609_at_wie.com>#1/1
Date: 1997/10/27
Message-ID: <34550FE3.C73C0609_at_wie.com>#1/1
ARN NGUYEN wrote:
> Hi,
>
> I have created a new user but now when I go into the form it won't let me
> query. SO far this user has priviliges 'execute...' , 'select any table',
> 'reference', 'index'.
>
> Please help
>
> Email
> s337202_at_student.uq.edu.au
>
> -Arn Nguyen
What errors does it give you? Do you have the tables as owned by this user or have you set up synonyms or a database link to these tables?
The correct commands should be.
Log on to databse that owns the tables.
create user user_name identified by password;
grant resource,connect to user_name;
grant insert,update,select,delete ON table_name_you_want_to_query TO
user_name;
I hope that helps! Received on Mon Oct 27 1997 - 00:00:00 CET