Users in oracle - Types of users posted by
Babu Kunwar
Types of users - a local user, an external user, or a global user
In Oracle a user is one who can connect to a database. We can authenticate users
in the database with three methods: database authentication, operating system
authentication, and network authentication methods. In database concept a local
user is one which has some authentication to connect to a particular database.
The rights of performing operation are being granted to user. After that he can
modify database structure as per the privileges provided by DBA.
When a user is authenticated with operating system then the user is known as
External User. In contrast, operating system authentication makes an assumption
that an external user who is already authenticated by an operating system
connection has the same privileges as a user with the same or similar name
depending on the value of the OS_AUTHENT_PREFIX initialization parameter.
Global User in Oracle database is one who is authenticated by SSL (Secure
Socket Layer) and that the management of these users is done outside of the
database by the centralized directory service.
More links
How compatible is Oracle Lite with the standard oracle server?
What is personal oracle lite?
Explain how to connect to a POL database
Explain how to write Java Stored Procedures
Explain how to replicate data using Oracle Lite............. .
|
