Back To Schedule
Thursday, March 22 • 8:30am - 9:30am
Oracle Privilege History

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
Have you ever dropped a table, user, or role by mistake and tried to restore privileges but couldn't remember what to grant or to whom? You queried the dba views only to find what is currently granted, not what was granted. Now, your only option is to guess which grants to make and then wait for people to complain, or processes to fail so you can figure out which grants were missed. Flashback is helpful, but won’t always solve the problem at hand. Creating a historical record of privileges will allow you to restore the correct suite of privileges to users or roles quickly and accurately without guessing. This presentation will provide steps to set up a process to track privileges historically.


Dallin Rogers

Intermountain Healthcare
I graduated from the University of Utah with a Master's Degree in Information Systems. I have been with Intermountain Healthcare for 7 years as a Data Architect on the EDW team. The last 3 years, I have been the EDW Database Operations Lead.Since my arrival, my coworkers have voted... Read More →

Thursday March 22, 2018 8:30am - 9:30am MDT
5180, 5th Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112