Notifications
Clear all
Topic starter
I have been writing my Crystal reports with the ML user up to this point and I realized I need to scale back the rights, especially after I almost made a change to a table without realizing it. I went and found the report user in the documentation and I am able to login to oracle with that account, however the usr table is unavailable when I do. How do I map tables that have a USERID field back to their name/login if I can not access the usr table with that account? Is there another table that has this information?
Posted : November 27, 2013 12:23 am
Topic starter
Nevermind, I think I found it. There is a view called USRINFO that has the information I need.
Posted : November 27, 2013 12:30 am