Home » RDBMS Server » Security » how to provide grant permission to other user for user defined datatype? (oracle 9i)
how to provide grant permission to other user for user defined datatype? [message #387103] Tue, 17 February 2009 23:07 Go to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Hi,

I had created a user defined datatype. I want to provide grant to others users too access the same.

My datatype name is mytabletype

kanish
Re: how to provide grant permission to other user for user defined datatype? [message #387104 is a reply to message #387103] Tue, 17 February 2009 23:10 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you

>I want to provide grant to others users too access the same.
GRANT.......
Re: how to provide grant permission to other user for user defined datatype? [message #387107 is a reply to message #387103] Tue, 17 February 2009 23:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Grant EXECUTE on it.

Regards
Michel
Re: how to provide grant permission to other user for user defined datatype? [message #387176 is a reply to message #387103] Wed, 18 February 2009 03:08 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Hi
i explain what i did

i created a user_defined type like below on dba

create or replace type myTableType as table of varchar2(200);


The above is used by another user. So as per your instruction i had provide execute provision

    grant execute any type to x;
    grant execute on mytabletype to x;



But still im getting the same error.

please help me solve this issue.

kanish
Re: how to provide grant permission to other user for user defined datatype? [message #387178 is a reply to message #387176] Wed, 18 February 2009 03:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
But still im getting the same error.

Which error Question There is no error in what you posted. Are you sure you are posting in the right topic?

Regards
Michel

[Updated on: Wed, 18 February 2009 03:11]

Report message to a moderator

Re: how to provide grant permission to other user for user defined datatype? [message #387180 is a reply to message #387103] Wed, 18 February 2009 03:15 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

SORRY
ORA-00902 - Invalid datatype;


kanish
Re: how to provide grant permission to other user for user defined datatype? [message #387190 is a reply to message #387103] Wed, 18 February 2009 03:55 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
And what code are you using to access this type to get this error?
Re: how to provide grant permission to other user for user defined datatype? [message #387198 is a reply to message #387103] Wed, 18 February 2009 04:18 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Thank for all

I solved it.

kanish
Re: how to provide grant permission to other user for user defined datatype? [message #387202 is a reply to message #387198] Wed, 18 February 2009 04:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And you think it is useless to post what you found and we are just here to give you help and be throwed away after that?

Regards
Michel
Re: how to provide grant permission to other user for user defined datatype? [message #387212 is a reply to message #387103] Wed, 18 February 2009 05:10 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

sorry,
After all permissin will be granted.

before i call
mytabletype

now i am using
dbauser.mytabletype


sorry again and thanks for all

kanish
Re: how to provide grant permission to other user for user defined datatype? [message #387213 is a reply to message #387212] Wed, 18 February 2009 05:14 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Create a synonym on your type if you don't want to prefix by the schema name.

Regards
Michel
Previous Topic: User roles and grants(indirect) (merged)
Next Topic: AUDIT in oracle 10g
Goto Forum:
  


Current Time: Fri Dec 09 05:47:44 CST 2016

Total time taken to generate the page: 0.23169 seconds