글
ERwin 논리명을 comment로, grant 자동생성
Database
2010. 10. 5. 15:37
출처 : http://www.sqler.com/113225
[ERwin 논리명을 comment로, grant 자동생성]
ERWin Database->Pre&Post Scripts
1. Model-level
%ForEachTable() {
COMMENT ON TABLE %TableName IS "%EntityName";
%ForEachColumn() {
COMMENT ON COLUMN %TableName.%ColName IS "%AttName";
}
}
2. Table-level
GRANT INSERT, UPDATE, DELETE ON SIM.%TableName to ROLE_SIM_W;
GRANT SELECT ON SIM.%TableName to ROLE_SIM_R;
CREATE PUBLIC SYNONYM %TableName FOR SIM.%TableName;
유져와 기타내용은 수정하시면 되며, 단지 예제일 뿐입니다.
[ERwin 논리명을 comment로, grant 자동생성]
ERWin Database->Pre&Post Scripts
1. Model-level
%ForEachTable() {
COMMENT ON TABLE %TableName IS "%EntityName";
%ForEachColumn() {
COMMENT ON COLUMN %TableName.%ColName IS "%AttName";
}
}
2. Table-level
GRANT INSERT, UPDATE, DELETE ON SIM.%TableName to ROLE_SIM_W;
GRANT SELECT ON SIM.%TableName to ROLE_SIM_R;
CREATE PUBLIC SYNONYM %TableName FOR SIM.%TableName;
유져와 기타내용은 수정하시면 되며, 단지 예제일 뿐입니다.
