OraFAQ Forum: Security » how to provide grant permission to other user for user defined datatype?

Home » RDBMS Server » Security » how to provide grant permission to other user for user defined datatype? (oracle 9i)

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

how to provide grant permission to other user for user defined datatype? [message #387103]

Tue, 17 February 2009 23:07

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

Report message to a moderator

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

BlackSwan
Messages: 26766
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.......

Report message to a moderator

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

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Grant EXECUTE on it.

Regards
Michel

Report message to a moderator

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

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

Report message to a moderator

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

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

mm_kanish05
Messages: 488
Registered: January 2007
Location: Chennai

Senior Member

SORRY

ORA-00902 - Invalid datatype;

kanish

Report message to a moderator

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

cookiemonster
Messages: 13904
Registered: September 2008
Location: Rainy Manchester

Senior Member

And what code are you using to access this type to get this error?

Report message to a moderator

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

mm_kanish05
Messages: 488
Registered: January 2007
Location: Chennai

Senior Member

Thank for all

I solved it.

kanish

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 23 19:08:37 CDT 2023