Create lable security
Download as PPTX, PDF
0 likes283 views
The document provides step-by-step instructions for creating an Oracle label security policy. It describes creating a new policy called "test_policy" with a label column called "Test_column". It also outlines adding levels, compartments, groups to the policy, then adding a user called "HR" and assigning them privileges and enabling auditing for the new policy.
Create lable security
- 1. Dr.GIRIJA NARASIMHAN 1 Create Label Security
- 5. Dr.GIRIJA NARASIMHAN LBACSYSCLICK RADIO BUTTONENABLE EXPIRED & LOCK (ACCOUNT STATUS)CLICK LBACSYS(UNDERLINE)
- 6. Dr.GIRIJA NARASIMHAN 6 Click the edit button
- 7. Dr.GIRIJA NARASIMHAN 7 Select unlock radio button Click system privileges
- 8. Dr.GIRIJA NARASIMHAN 8 System privileges edit select any dictionary move Logout sys
- 9. Dr.GIRIJA NARASIMHAN 9 Restart these two services again i.e restart the database instance and login LBACSYS
- 10. Dr.GIRIJA NARASIMHAN 10 Again restart service
- 12. Dr.GIRIJA NARASIMHAN 12 Server oracle label security
- 13. Dr.GIRIJA NARASIMHAN 13 Click create button for creating new policy
- 14. Dr.GIRIJA NARASIMHAN 14 enabled Select radio button Apply No policy enforcement (no_control) Name->test_policy label column Test_column
- 16. Dr.GIRIJA NARASIMHAN 16 Policy- label components
- 17. Dr.GIRIJA NARASIMHAN 17 Click levels add 5 rows
- 18. Dr.GIRIJA NARASIMHAN 18 Type long_name, short name, numeric tag select all
- 19. Dr.GIRIJA NARASIMHAN 19 Once type level, compartment, group click apply button
- 20. Dr.GIRIJA NARASIMHAN 20 Action Click Data Label and click Go button
- 21. Dr.GIRIJA NARASIMHAN 21 Click add users it will display the database user
- 22. Dr.GIRIJA NARASIMHAN 22 Select the HR user or any user
- 23. Dr.GIRIJA NARASIMHAN 23 Here add HR user Press next button
- 25. Dr.GIRIJA NARASIMHAN 25 Whichever relevant select policy privileges
- 26. Dr.GIRIJA NARASIMHAN 26 Enable the Audit operation
- 28. Dr.GIRIJA NARASIMHAN 28 Data label created for user HR