Home » RDBMS Server » Server Administration » Permission is available but not workings ....? (Oracle 9i , Widows XP)
icon11.gif  Permission is available but not workings ....? [message #290057] Thu, 27 December 2007 05:00 Go to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Hi Guru,


I have given a permission for a table "Cenvatpart" from "ACCL" user to "Cenvat" User.

GRANTEE OWNER TABLE_NAME GRANTOR PRIVILEGE GRA HIE
CENVAT ACCL CENVATPART ACCL ALTER NO NO
CENVAT ACCL CENVATPART ACCL DELETE NO NO
CENVAT ACCL CENVATPART ACCL INDEX NO NO
CENVAT ACCL CENVATPART ACCL INSERT NO NO
CENVAT ACCL CENVATPART ACCL SELECT NO NO
CENVAT ACCL CENVATPART ACCL UPDATE NO NO
CENVAT ACCL CENVATPART ACCL REFERENCES NO NO
CENVAT ACCL CENVATPART ACCL ON COMMIT REFRESH NO NO
CENVAT ACCL CENVATPART ACCL QUERY REWRITE NO NO
CENVAT ACCL CENVATPART ACCL DEBUG NO NO
CENVAT ACCL CENVATPART ACCL FLASHBACK NO NO


11 rows selected.


Which is available when i execute the user_tab_privs
query for the particular user on particular table eventhough when i log on to the cenvat user, to access tabel which tell "TAble/ View Does Not Exist"

Please Help Me

By

Kanish
Re: Permission is available but not workings ....? [message #290060 is a reply to message #290057] Thu, 27 December 2007 05:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use SQL*Plus and copy and paste what you execute, don't just describe it.

Read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
Always post your Oracle version (4 decimals).

Regards
Michel
Re: Permission is available but not workings ....? [message #290062 is a reply to message #290057] Thu, 27 December 2007 05:12 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Use owner_name.table_name to access other schema's table if you don't have synonym.
Previous Topic: database is not open
Next Topic: to kill the session
Goto Forum:
  


Current Time: Sat Dec 10 10:58:16 CST 2016

Total time taken to generate the page: 0.10372 seconds