ACL - don't understand access format

[djk]

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.

[Hoff · Accepted solution]

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]

This information was very helpfull.