Data Modeling and Design_Unit2_DB2

Data Modeling and Design_Unit2_DB2 - Data Modeling and...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Data Modeling and Design Unit 2 Discussion Board Kregg M. Soltow March 30, 2011 American Intercontinental University How could the above business rules be set up in a database and reinforced using DCL? DCL or Data Control Language, can be used to control certain access to the given inventory database by establishing a simple set of either a “GRANT” or “REVOKE” permission for one or more specific privileges. Such privileges include; CONNECT, SELECT, INSERT, UPDATE, DELETE, EXECUTE and USAGE. The first permission, GRANT will be utilized for both the manager and the clerk but each will be accompanied by additional privileges to distinguish the amount of information usability each has. For instance; GRANT/SELECT/INSERT/DELETE/UPDATE – to – Master Item Inventory – to Store Manger will allow the store manager to not only view but add, delete and make changes to the Master Item Inventory table. However the Clerk will only require something along the lines of; GRANT/SELECT – to – Master Item Inventory – to Clerk, which will allow
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 2

Data Modeling and Design_Unit2_DB2 - Data Modeling and...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online