I am trying to develop an ASP.net app which runs against an Oracle database. I have a package which has all of my procedures in it and I'm trying to write a procedure which can check a given username/password against the Oracle ones. The proc takes arguments of username and password and I'm trying to validate them. I suspect I will need to use DBA_USERS table to do this, but when I try and code SELECT statments in the proc I get "table or view does not exist" for dba_users. I tried giving my user SELECT_CATALOG_ROLE (briefly) and it made no difference.
Does anybody else do anything like this? Can anyone give an guidance please?
Thanks for your help