- This event has passed.
Hardening the Oracle Database with Privilege Analysis
July 7, 2021 @ 1:00 pm - 2:00 pm EDT
Determining What Privileges are Actually Required and Removing Those That Aren’t
Do you know exactly what your users can do in (or to) your databases?
Learn how to determine what privileges users actually need – and safely revoke those that they should not have. An essential question for any DBA or developer concerned about Oracle Database security.
Historically, it has been really difficult to work out how a user gets permission to do something. It could be by a direct grant of an object privilege. Or a grant of an ANY system privilege. Or a grant to PUBLIC. Or through a role. Or a grant of a privilege to a role granted to another role granted to PUBLIC. Writing SQL to navigate the various DBA%PRIVS views that document this is a horrible exercise.
No need to do that any more! Release 12.1 introduced the Privilege Analysis facility, implemented with the dbms_privilege_capture package. Originally part of Data Vault, it is now de-licensed and available as part of Enterprise Edition. This webinar will describe what it can do for you, with (of course!) demonstrations of all the capabilities.
Prerequisite Knowledge
Basic SQL, PL/SQL and DBA skills.
Presenters
John Watson, Oracle Certified Master DBA, SkillBuilders Director of All Things Oracle Database
Dave Anderson, SkillBuilders’ Founder, Oracle DBA
Recording
Barring any technical glitches, all webinars are recorded and posted as tutorials. See all tutorials HERE
Registration
By registering for the webinar, you will be placed on SkillBuilders mailing list. You will have the option to opt-out of the mailing list at any time. An extra-special event!
All dates are in Eastern Time (ET).