- In Oracle, once a profile is assigned to a user, the profile cannot be revoked. (true/false).
- You can assign many profiles to a user (true/false). (Please test it by assigning several profiles to a user and see what happened.)
- You can drop a public role and recreate it with different privileges (true/false)
- What Oracle data dictionary view do you use to display a password policy for a specific user?
- Explain when and why you would use roles
- Using Oracle, produce a report that show which user if any is assigned any of the following roles DBA and SELECT_CATALOG_ROLE.
- List all object privileges granted to Oracle user OE (order Entry). OE is a user created by default installation of Oracle10g.
- Provide a scenario describing when you would provide the SELECT ANY TABLE privilege.
|
