DATABASE SECURITY( IN ORACLE) You were promoted to a project leader position at

Question

DATABASE SECURITY( IN ORACLE)

You were promoted to a project leader position at a software company that specializes in security application development. Your manager assigned you to design and develop a prototype (template) for a client. The client will use this prototype to implement the application. Your job is to provide this prototype according to these requirements:

* The application must use the following security access levels: 0=none, 1=select, 2= update, 3=delete

* A user should only see rows that are created by the user

* A user with security access of level 6 can use SELECT, UPDATE, and DELETE functions (1+2+3), even if the row does not belong to the current user.

*Each row is assigned a security level.

* Each user is assigned a security level.

Explanation / Answer

for this we have to create a table where id will be there for each row. create level with int type in the mysql table and then while creating users we can give levels to them. For person with level 6 show them a GUI to execute sql queries.

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.