Home » SQL & PL/SQL » SQL & PL/SQL » GRANTING PROBLEM ,TELL ME THE CORRECT SYNTAX.WITH EXAMPLE
GRANTING PROBLEM ,TELL ME THE CORRECT SYNTAX.WITH EXAMPLE [message #197926] Fri, 13 October 2006 05:15 Go to next message
lunate
Messages: 74
Registered: October 2006
Location: Pakistan
Member

HI,GUYS.

IS THIS IS POSSIBLE TO PERFORM AN OPERATION SUCH AS SELECT ,DELETE ,INSERT ON A TABLE OF ANOTHERE USER(SCHEMA)WITH OUT REFERING THE USER NAME(SCHEMA).
EXAMPLE :
SCOTT >GRANT SELECT,DELETE ,INSERT ON EMP
TO LUNATE;

SQL>CONNECT LUNATE

LUNATE>SELECT * FROM EMP;--- IS THIS POSSIBLE.

WITH REGARDS.

LUNATE:)
Re: GRANTING PROBLEM ,TELL ME THE CORRECT SYNTAX.WITH EXAMPLE [message #197927 is a reply to message #197926] Fri, 13 October 2006 05:18 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,

 synonyms will solve your purpose.



regards,
Re: GRANTING PROBLEM ,TELL ME THE CORRECT SYNTAX.WITH EXAMPLE [message #197956 is a reply to message #197926] Fri, 13 October 2006 07:54 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Or a view.
Re: GRANTING PROBLEM ,TELL ME THE CORRECT SYNTAX.WITH EXAMPLE [message #197972 is a reply to message #197956] Fri, 13 October 2006 09:32 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Or 'ALTER SESSION SET current_schema = SCOTT;'
Previous Topic: reports using three tables
Next Topic: How to debug in SqlPlus ( .sql file )
Goto Forum:
  


Current Time: Tue Dec 06 08:53:11 CST 2016

Total time taken to generate the page: 0.28502 seconds