Re: User Priviliges

Hi !

Don't forget to specify schema for the tables used

ex :

        scott.emp
        scott.emp.emp_id
        ...

    => select emp_id from scott.emp where .... ;

or make synonyms in your new schema to the table owned by others (more difficult)
or make public synonyms from owner's tables to public (more dangerous for security)

Hope this help.

--
REIP Jean-Claude
Enlevez ".remove.this" de l'adresse (anti-spam)
jacari.consultant.remove.this_at_skynet.be
Tim McConechy wrote in message <34550FE3.C73C0609_at_wie.com>...


>

>

>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!

>

>

>