OraFAQ Forum: Server Administration » Permission is available but not workings ....?

Home » RDBMS Server » Server Administration » Permission is available but not workings ....? (Oracle 9i , Widows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Permission is available but not workings ....? [message #290057]

Thu, 27 December 2007 05:00

mm_kanish05
Messages: 493
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

Report message to a moderator

Re: Permission is available but not workings ....? [message #290060 is a reply to message #290057]

Thu, 27 December 2007 05:09

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: Permission is available but not workings ....? [message #290062 is a reply to message #290057]

Thu, 27 December 2007 05:12

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.

Report message to a moderator

Previous Topic:	database is not open
Next Topic:	to kill the session

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 14:18:31 CDT 2024