4. Several levels of file access were discussed in this chapter, including read/

Question

4. Several levels of file access were discussed in this chapter, including read/ write, read-only, execute-only, and no access. Assume you maintain a database containing confidential patient information and need to restrict UPDATE to only 5 individuals, allow only 15 others to view the database, and disallow any database access to all other users. Which access level would you assign to the 20 individuals in the first two groups and to the remaining users? For each of the three groups, describe every type of access granted to each one.

Explanation / Answer

Assume you maintain a database containing confidential patient information and need to restrict UPDATE to only 5 individuals, allow only 15 others to view the database, and disallow any database access to all other users.

ANSWER:

For this first we need to create users

CREATE USER <<user name>> IDENTIFIED BY <<password>>

Using this N number of users

After creating users ,grant created users to connect Database

GRANT CONNECT TO <<user name>>

We need to create session to users

GRANT CREATE SESSION TO<<user name>>

we are giving read-only access to 15 users

GRANT SELECT any table to <<user name>>

Restrict to update 5 users

GRANT UPDATE any table to <<user name>>

Disallow all other users means we can drop users or revoke the privileges

REVOKE CONNECT TO <<user name>>

                                                OR

REVOKE SESSION TO<<user name>>

Related Questions

Navigate

• Browse (All)
• Browse 4
• Subjects

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