Operating System - OpenVMS
1748280 Members
3861 Online
108761 Solutions
New Discussion юеВ

Re: ACL - don't understand access format

 
SOLVED
Go to solution
djk
Advisor

ACL - don't understand access format

I have an RDB database file that has the following ACL -

(IDENTIFIER=DATABASE,ACCESS=READ+WRITE+BIT_5+BIT_6+BIT_7+BIT_8+BIT_9+BIT_10+BIT_11+BIT_12+BIT_13+BIT_14+BIT_16+BIT_17+BIT_18)

I don't understand what the "+BIT_5" ... stuff means. Any insight would be appreciated.
2 REPLIES 2
Hoff
Honored Contributor
Solution

Re: ACL - don't understand access format

Oracle Rdb uses (and extends) the VMS ACLs, but has its own format. (VMS ACLs have a parsing and a formatting call, and these tools can be extended.)

See the SQL show protection command and see the RMU available commands including set protection, as a start.

Search the Oracle site (Google site:oracle.com keyword) for additional details. Here are a couple of references that'll get you into the right area and commands:

http://www.oracle.com/technology/products/rdb/pdf/role_based_security.pdf

http://www.oracle.com/technology/products/rdb/pdf/stored_procedure_security.pdf

Put another way, it appears you're looking at the access control list entry (ACE) records in the access control list (ACL) directly, rather than looking at the ACEs in the ACLs through Rdb and RMU or SQL.

Or you've got a corruption of some sort.

I'd also suggest heading over to Oracle and Metalink, as that's where this Rdb stuff is likely best discussed. Particularly if something got stomped on.
djk
Advisor

Re: ACL - don't understand access format

This information was very helpfull.