[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
Title: | Oracle CDD/Repository nce |
Notice: | Current versions are V7.0-01 and V6.1-03 eld Test 3 |
Moderator: | 8292::PJACOB N |
|
Created: | Thu Jan 21 1993 |
Last Modified: | Fri Jun 06 1997 |
Last Successful Update: | Fri Jun 06 1997 |
Number of topics: | 1094 |
Total number of notes: | 4913 |
1057.0. "Question on dictionary protection" by M5::GHODSON () Tue Feb 25 1997 14:45
I have a customer that is using one repository with multiple directories
below the top level, one for each user. He would like each user to
have full access to their directory and not be able to define elements
in the top level or the other users' directories.
I have not been able figure a way to give them access to one specific
directory without also giving access to the top level. Is there a way
to do this?
For example:
From a privileged session:
CDO> show protection for repository DISK$USR3:[GHODSON.CDDTEST]
Directory DISK$USR3:[GHODSON.CDDTEST]CDD$PROTOCOLS
CDD$SELF
(IDENTIFIER=[WWS,GHODSON],ACCESS=READ+WRITE+MODIFY+ERASE+SHOW+DEFINE+
CHANGE+DELETE+CONTROL+OPERATOR+ADMINISTRATOR)
(IDENTIFIER=[*,*],ACCESS=READ+SHOW)
Default acl
(IDENTIFIER=[WWS,GHODSON],ACCESS=READ+WRITE+MODIFY+ERASE+SHOW+DEFINE+
CHANGE+DELETE+CONTROL+OPERATOR+ADMINISTRATOR)
(IDENTIFIER=[*,*],ACCESS=READ+SHOW)
CDO> show protection for directory DISK$USR3:[GHODSON.CDDTEST]test1
Directory DISK$USR3:[GHODSON.CDDTEST]
TEST1
(IDENTIFIER=[WWS,GHODSON],ACCESS=READ+SHOW)
(IDENTIFIER=[*,*],ACCESS=READ+WRITE+SHOW+CHANGE)
Then from another login session for a nonpriv user:
CDO> show def
DISK$USR3:[GHODSON.CDDTEST]TEST1
CDO> show privilege for directory DISK$USR3:[GHODSON.CDDTEST]test1
Directory DISK$USR3:[GHODSON.CDDTEST]
TEST1
(IDENTIFIER=[*,*],ACCESS=READ+WRITE+SHOW+CHANGE)
CDO> define field test3 datatype is text size is 10.
%CDO-E-ERRDEFINE, error defining an object
-CDD-E-NOWRITE, no privilege to write DISK$USR3:[GHODSON.CDDTEST]
Thanks for any help.
--Gary Hodson
T.R | Title | User | Personal Name | Date | Lines
|
---|