Skip to Main Content
  • Questions

  • function that does not allow a non user to login to the application

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Raj.

Asked: September 04, 2018 - 9:33 am UTC

Last updated: September 04, 2018 - 10:02 am UTC

Version: Oracle 11g

Viewed 1000+ times

You Asked

Hello,

There is a requirement for us where non users should be restricted from logging to the application in a trigger in Oracle forms which use PL SQL. This needs to be done using a new database function.
I only have a developer access and not a DBA. How can we do this, kindly suggest.

Thanks,
Raj.

and Chris said...

I'm not sure what you mean by "non-users". Surely they have no password so can't login anyway?

If you're using database users for authentication, you can use login triggers to stop certain people logging into the database. See:

https://asktom.oracle.com/pls/asktom/asktom.search?tag=after-logon-on-database
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:3236035522926

If you've got custom authentication, you'll need to provide details about what exactly you're doing and why it doesn't work.

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database