Home » SQL & PL/SQL » SQL & PL/SQL » give privilages to users
give privilages to users [message #226504] Sat, 24 March 2007 05:36 Go to next message
Messages: 4
Registered: November 2005
Location: Pakistan
Junior Member

hi dear,

i have problem to give privilages to users..i have create user n give privliages to user(create session,create any procedure,select,execute) but problem is..when i select fuction from an other sechama it will not allow to select or insert of funtion of another sechma...plz send me the qurey to select or insert the funtion of another sechama.

Re: give privilages to users [message #226511 is a reply to message #226504] Sat, 24 March 2007 07:50 Go to previous message
Messages: 21127
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
OK, you gave required privileges. But, you didn't mention the way you are communicating with another schema. I *guess* you forgot to include owner's name. For example, connected as 'scott'
SQL> grant select on dept to kriz;

Grant succeeded.
Now connect as another user:
SQL> connect kriz/kriz@ora10
SQL> select * from dept;
select * from dept
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> select * from scott.dept;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        50 MANAGING       ZAGREB
        67 a              b
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON

6 rows selected.


So, are you missing schema name? If not, could you explain it a little bit better (and paste actual SQL*Plus session)?
Previous Topic: Grouping
Next Topic: how to give foreign key references from one user table to another user table
Goto Forum:

Current Time: Sun Jul 23 04:08:43 CDT 2017

Total time taken to generate the page: 0.07609 seconds