469,090 Members | 1,196 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

Grant Previleges to Objects and Varrays

create TYPE temp1 AS OBJECT (
col1 VARCHAR2(20),
col2 VARCHAR2(20)
)
/

create TYPE temp1_array
AS VARRAY (6) OF temp1
/

Instead of giving execute privilege on Object, I would like to grant
the execute privilege only on temp1_array to USER1. Does it grant
indirectly execute privilege on Temp1 object or do I have to grant
execute privilege to temp1 object explicitly?
Jul 19 '05 #1
1 3046
HI.

You can grant execute on temp1_array to USER1 and see that the only
granted object is temp1_array with:

select * from user_tab_privs where table_name like 'TEMP1%';

So, with USER1, you can reference temp1_array but not temp1.

Bye.

kv******@yahoo.com (KVN Chary) wrote in message news:<b6*************************@posting.google.c om>...
create TYPE temp1 AS OBJECT (
col1 VARCHAR2(20),
col2 VARCHAR2(20)
)
/

create TYPE temp1_array
AS VARRAY (6) OF temp1
/

Instead of giving execute privilege on Object, I would like to grant
the execute privilege only on temp1_array to USER1. Does it grant
indirectly execute privilege on Temp1 object or do I have to grant
execute privilege to temp1 object explicitly?

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Charles Cantrell | last post: by
reply views Thread by richasaraf | last post: by
20 posts views Thread by Praveen | last post: by
1 post views Thread by richard | last post: by
3 posts views Thread by Chris Ochs | last post: by
6 posts views Thread by john_woo | last post: by
1 post views Thread by KVN Chary | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.