Subversion Repositories DevTools

Rev

Rev 51 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 51 Rev 53
Line 487... Line 487...
487 
ROLE_ID
 487 
ROLE_ID
488 
) ENABLE
 488 
) ENABLE
489 
;
 489 
;
490 
 
 490 
 
491 
ALTER TABLE DATA_PERMISSIONS
 491 
ALTER TABLE DATA_PERMISSIONS
492 
ADD CONSTRAINT FK_DATA_PERM_REF_PERM_TYPES FOREIGN KEY
 492 
ADD CONSTRAINT FK_DATA_PERM_REF_DATA_TABLE FOREIGN KEY
493 
(
 493 
(
494 
  PERM_ID
 494 
  DT_ID
495 
)
 495 
)
496 
REFERENCES PERMISSION_TYPES
 496 
REFERENCES DATA_TABLES
497 
(
 497 
(
498 
PERM_ID
 498 
DT_ID
499 
) ENABLE
 499 
) ENABLE
500 
;
 500 
;
501 
 
 501 
 
502 
ALTER TABLE DATA_PERMISSIONS
 502 
ALTER TABLE DATA_PERMISSIONS
503 
ADD CONSTRAINT FK_DATA_PERM_REF_DATA_TABLE FOREIGN KEY
 503 
ADD CONSTRAINT FK_DATA_PERM_REF_PERM_TYPES FOREIGN KEY
504 
(
 504 
(
505 
  DT_ID
 505 
  PERM_ID
506 
)
 506 
)
507 
REFERENCES DATA_TABLES
 507 
REFERENCES PERMISSION_TYPES
508 
(
 508 
(
509 
DT_ID
 509 
PERM_ID
510 
) ENABLE
 510 
) ENABLE
511 
;
 511 
;
512 
 
 512 
 
513 
ALTER TABLE USER_ROLES
 513 
ALTER TABLE USER_ROLES
514 
ADD CONSTRAINT FK_USER_ROLES_REF_ROLES FOREIGN KEY
 514 
ADD CONSTRAINT FK_USER_ROLES_REF_ROLES FOREIGN KEY
Line 596... Line 596...
596 
(
 596 
(
597 
APP_ID
 597 
APP_ID
598 
) ENABLE
 598 
) ENABLE
599 
;
 599 
;
600 
 
 600 
 
- 
 
 601 
CREATE OR REPLACE VIEW CONTROLOBJECTS_VS_ROLES AS select distinct app.app_id, app.application_name, co.obj_id, co.obj_name, co.obj_description, ro.role_id, ro.role_name
- 
 
 602 
from applications app, control_objects co, roles ro, role_privileges rp
- 
 
 603 
where app.app_id=co.app_id
- 
 
 604 
and app.app_id=ro.app_id
- 
 
 605 
and ro.role_id=rp.role_id
- 
 
 606 
and rp.obj_id=co.obj_id
- 
 
 607 
order by co.obj_name;
- 
 
 608 
 
601 
CREATE UNIQUE INDEX UNQ_CONTROL_OBJ ON CONTROL_OBJECTS (APP_ID ASC, OBJ_NAME ASC)  TABLESPACE "USERS"
 609 
CREATE UNIQUE INDEX UNQ_CONTROL_OBJ ON CONTROL_OBJECTS (APP_ID ASC, OBJ_NAME ASC)  TABLESPACE "USERS"
602 
  LOGGING
610 
  LOGGING
603 
  PCTFREE 10
 611 
  PCTFREE 10
604 
  INITRANS 2
 612 
  INITRANS 2
605 
  MAXTRANS 255
 613 
  MAXTRANS 255