Re: OPS$users

"Vorname Name" <Vorname.Name_at_pcm.bosch.de> writes:

> Hello,
>
> I would like to know how to create an oracle user account with similar
> user and password as the NT username and password i.e. to log on to Oracle
> the NT username and password should be used for authentication and no
> special password is required.
> I am not sure how to create such users but i think such users have OPS$
> extensions.
> I would be grateful to any help provided.
No problem. The steps involved are pretty simple.

You don't actually need to create the users using the OPS$ prefix. It was used in the past to distinguish users identified by external means from those users that use passwords. However, these days that's done by creating the users IDENTIFIED EXTERNALLY. In fact, I would recommend setting it to nothing as it allows longer user names.

Here are the instructions:
1. If you decide not to use the default prefix:

1. Edit init<sid>.ora. Add the following line: os_authent_prefix=""
2. Bounce the database
3. For echo user:
4. CREATE USER <insert user name> IDENTIFIED EXTERNALLY; If you decide to keep the OPS$ prefix, this statement should be: CREATE USER OPS$<insert user name> IDENTIFIED EXTERNALLY;
5. Grant the roles and privileges as you do with any user.

When the user connects, he/she will not have to specify any username or password at all as in "sqlplus /"

                                        Hope this helps,
-- 
                                        Rick
                                        Rick Wessman
                                        Security and Directory Technologies
                                        Server Technologies
                                        Oracle Corporation
                                        rwessman_at_us.oracle.com