Oracle 12c Upgrade: 05 – Managing Tablespaces Common and Local Users Privileges and Roles

Card Set Information

Author:
Tralala
ID:
296065
Filename:
Oracle 12c Upgrade: 05 – Managing Tablespaces Common and Local Users Privileges and Roles
Updated:
2015-03-16 03:27:20
Tags:
Managing Tablespaces Common Local Users Privileges Roles
Folders:
Oracle 12c Upgrade
Description:
Oracle 12c Upgrade: 05 – Managing Tablespaces, Common and Local Users, Privileges and Roles
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user Tralala on FreezingBlue Flashcards. What would you like to do?


  1. How are common objects are visible in the PDBs?
    Through object links
  2. What is significant about UNDO tablespace?
    There is only one UNDO tablespace for the entire CDB
  3. If DBA_TABLESPACES and DBA_DATA_FILES is queried as SYS in the CDB, what is seen?
    Only tablespaces and data files that are part of Root container
  4. Which views will show tablespaces and datafiles for the entire CDB?
    • CDB_TABLESPACES
    • CDB_DATA_FILES
  5. When issuing a CREATE TABLESPACE command, where is the tablespace created?
    In the container to which you are currently connected
  6. If 'ALTER DATABASE DEFAULT TABLESPACE USERS' is issued in root, which containers are affected?
    Only the CDB
  7. How is the default tablespace changed in a PDB?
    ALTER PLUGGABLE DATABASE DEFAULT TABLESPACE USERS
  8. ALTER PLUGGABLE DATABASE must be issued where?
    Connected to the PDB
  9. How do temporary tablespace work in a CDB?
    • A CDB is allowed one default temporary tablespace or tablespace group
    • All PDB user use the CDB temporary as their default temporary tablespace
    • A PDB can have its own temporary tablespace and assign users to it.
    • If a default temporary tablespace is not specified for a PDB, PDB users will use the CDB.
  10. To what does a permanent tablespace belong?
    The PDB that created it.
  11. To create a COMMON user, what privileges are required?
    CREATE USER and SET CONTAINER
  12. What do COMMON usernames always start with?
    C##
  13. How does a local user create a common user?
    It can't
  14. What is the default for CONTAINER where a common user connects to root?
    All
  15. What is the default for CONTAINER where a common user connects to a PDB?
    CURRENT
  16. If c##user1 is given CREATE SESSION on CDB$ROOT, can they connect to PDB01:
    No, this must also be granted
  17. What is the scope of a local user?
    Local users are only known in a specific PDB, they can’t perform actions outside the scope of the PDB where they have been created.
  18. Where is it not possible to create a local user?
    CDB$ROOT
  19. What happens if a local user grant a COMMON user a privilege?
    It fails
  20. A what level can privileges exist?
    LOCAL or COMMON
  21. What users can be granted LOCAL privileges?
    LOCAL users
  22. What privileges can a COMMON user have?
    LOCAL and COMMON
  23. If a LOCAL user is granted a COMMON role (ie SELECT ANY TABLE), what is the scope of the privilege?
    LOCAL only
  24. What is the prefix for a LOCAL role?
    C##
  25. What are the requirements to create a COMMON user?
    • You must be connected to a common user with the CREATE USER privilege.
    • The current container must be the root container.
    • The username for the common user must be prefixed with "C##" or "c##" and contain only ASCII or EBCDIC characters.
    • The username must be unique across all containers.
    • The DEFAULT TABLESPACE, TEMPORARY TABLESPACE, QUOTA and PROFILE must all reference objects that exist in all containers.
    • You can either specify the CONTAINER=ALL clause, or omit it, as this is the default setting when the current container is the root.
  26. What is the syntax to create a COMMON user?
    CREATE USER c##test_user2 IDENTIFIED BY password CONTAINER=ALL;
  27. When creating a COMMON user and the CONTAINER=ALL clause is omitted, what is the result?
    It is implied
  28. What are the requirements to create a COMMON user?
    • The username for the local user must not be prefixed with "C##" or "c##".
    • The username must be unique within the PDB.
    • You can either specify the CONTAINER=CURRENT clause, or omit it, as this is the default setting when the current container is a PDB.
  29. If a local user is a DBA user, what privilege is required?
    PDB_DBA
  30. What is the syntax to create a LOCAL user?
    CREATE USER test_user3 IDENTIFIED BY password CONTAINER=CURRENT;
  31. What are the requirements to create a COMMON role?
    • You must be connected to a common user with CREATE ROLE and the SET CONTAINER privileges granted commonly.
    • The current container must be the root container.
    • The role name for the common role must be prefixed with "C##" or "c##" and contain only ASCII or EBCDIC characters.
    • The role name must be unique across all containers.
    • The role is created with the CONTAINER=ALL clause
  32. What are the requirements to create a LOCAL role?
    • You must be connected to a user with the CREATE ROLE privilege.
    • If you are connected to a common user, the container must be set to the local PDB.
    • The role name for the local role must not be prefixed with "C##" or "c##".
    • The role name must be unique within the PDB.
  33. To whom can a local role be granted?
    Local or common user or role
  34. What kind of privileges can a local user be granted?
    Only local privileges
  35. What kind of privileges can a common user be granted?
    Local and Common
  36. Where can a commonly granted privilege be used?
    In all PDBs and Root
  37. Who can grant common privileges?
    A common user
  38. What kind of privilege can be granted commonly?
    System and object
  39. Can a local privilege apply to the root container?
    Yes. grant drop user to c##_sam container=current
  40. Who can grant privileges locally?
    Common and Local users
  41. To whom can local privileges be granted
    Common and Local users
  42. How would drop user privilege be removed for common user c##bob for all containers
    REVOKE DROP USER FROMM C##BOB CONTAINER=ALL
  43. What kind of roles are defined in a Multitenant environment?
    Local and Common
  44. Where are common roles visible?
    In all PDBs and Root
  45. What kind of roles are Oracle predefined roles classed as?
    Common roles
  46. What can a local user do with a common role?
    • Can't create a common role
    • Can grant a common role to common and local users
  47. What can a common user do with a common role?
    • Can create a common role
    • Can grant a common role to common and local users
  48. What is the scope of a common role granted to a local user?
    Only applicable to the local user's PDB
  49. If a common role contains locally granted privileges, what is the scope of the role?
    Locally granted privileges will only apply the the PDB in which they were granted
  50. How is a local role created?
    create role local_pdb1 container=current;
  51. How is a common role created?
    create role c##Role1 container = all;
  52. How must common roles be prefixed??
    With C## or c##
  53. When granting a privilege to a role, what is the default container
    CONTAINER=CURRENT. CONTAINER=ALL always has to explicitly defined

What would you like to do?

Home > Flashcards > Print Preview