Since Oracle 9i Release 2 it has been possible to create proxy users, allowing us to access a schema via a different username/password combination. If a user leaves a project, you simply lock or drop their user, and they no longer have access to the shared schema. Instead you create a separate proxy user for each individual, allowing them to connect to the schema owner with their own credentials. Letting multiple people share the same credentials represents a security risk. You have multiple developers working in a shared schema.This can present a problem if the administrator doesn't know the password. Some DBA tasks, like creating private database links or setting up jobs using the DBMS_JOB package, require the administrator to log in as a specific user.There are a two main reasons for using proxy users. Home » Articles » Misc » Here Proxy User Authentication and Connect Through in Oracle DatabasesĬonnect to other database users without knowing their passwords using proxy users.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |