ACL - don't understand access format

djk — Thu, 08 Jul 2010 21:10:34 GMT

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.

Re: ACL - don't understand access format

Hoff — Thu, 08 Jul 2010 21:28:47 GMT

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.

Re: ACL - don't understand access format

djk — Fri, 09 Jul 2010 18:47:18 GMT

This information was very helpfull.

topic Re: ACL - don't understand access format in Operating System - OpenVMS

ACL - don't understand access format

Re: ACL - don't understand access format

Re: ACL - don't understand access format