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
reehan
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.


thanks
farooq.
Re: give privilages to users [message #226511 is a reply to message #226504] Sat, 24 March 2007 07:50 Go to previous message
Littlefoot
Messages: 20888
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
Connected.
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.

SQL>

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: Sat Dec 03 07:47:03 CST 2016

Total time taken to generate the page: 0.14874 seconds