Revision 6923
Added by ben leinfelder about 11 years ago
| xmltables-oracle.sql | ||
|---|---|---|
| 282 | 282 |
*/ |
| 283 | 283 |
CREATE TABLE xml_access ( |
| 284 | 284 |
guid VARCHAR2(2000), -- the globally unique string identifier |
| 285 |
accessfileid VARCHAR2(250), -- the document id # for the access file
|
|
| 285 |
accessfileid VARCHAR2(2000), -- the id for the access file
|
|
| 286 | 286 |
principal_name VARCHAR2(100), -- name of user, group, etc. |
| 287 | 287 |
permission NUMBER(1), -- "read", "write", "all" |
| 288 | 288 |
perm_type VARCHAR2(32), -- "allowed" or "denied" |
Also available in: Unified diff
use larger ("text") db field for guid in the xml_access.accessfileid column