Grant a cluster?

From: Nirmal Kumar Muthu Kumaran <NIRMALK_at_qtel.com.qa>
Date: Sat, 24 Nov 2001 06:39:51 -0800
Message-ID: <F001.003CC496.20011124061516@fatcity.com>

Hi.. guru's...

Sorry if it's a basic question....

Can i grant a grant a cluster to any user?....

Oracle document says, the object may be a table/view/sequence/synonym/procedure/package/funtion/...etc.,.... except cluster.

It means, we cann't grant a clusters?....

I don't think so it's not possible, since the all_clusters object having "owner" column,

SCOTT_at_ORANS.QTEL.COM.QA> select owner, cluster_name from all_clusters;

OWNER                          CLUSTER_NAME
------------------------------ ------------------------------
SYS                            C_OBJ#
SYS                            C_USER#
SYS                            C_FILE#_BLOCK#
SYS                            C_TS#
SYS                            C_COBJ#
SYS                            C_MLOG#
SYS                            C_RG#
SYS                            C_OBJ#_INTCOL#
SYS                            C_TOID_VERSION#
SCOTT                          MY_CLUSTER

10 rows selected.

This give meaning that the cluster objects "c_"... are granted to scott rt?....

Please clear me...

Thanks.

Nirmal. Received on Sat Nov 24 2001 - 08:39:51 CST