| AD Domain Group - Windows [message #664202] |
Thu, 06 July 2017 13:53  |
 |
XpertDBA99
Messages: 2
Registered: July 2017
|
Junior Member |
|
|
Hello,
I'm a bit new to Oracle on Windows, and am trying to figure out how AD Domain Groups work with Oracle and Windows. I pulled up the Oracle Administration Assistant for Windows and added in 2 domain groups to the OS Database Administrators - Computer item and also added the same 2 domain groups to the Database OS Database Administrators item for that database (Let's just call the database ORCL, and the 2 domain groups we'll call COMPANY\DevCenter Tech and COMPANY\DevCenter DBA)
Once I've done that, what other things to I need to do to make the users of these groups be able to access the database? What do the members of these groups use to log into the database without a password? (Examples please). Let's say my userid is FFRED and I'm part of either of the 2 domain groups. What do I enter in SQLPLUS to log into the database without a password? Do I need to add FFRED or either of the DevCenter AD Domains as users explicitly in the database, or has that already been taken care of for me by what I did in the Oracle Administration Assistant for Windows?
Can I login without having to specify who I am, since I'm already part of one of the AD Domain Groups?
I read some stuff about the OPS$ string being appended to the userid, so not sure I understand about that either.
Any information would be helpful, thanks.
Robert
|
|
|
|
|
|
| Re: AD Domain Group - Windows [message #664206 is a reply to message #664203] |
Thu, 06 July 2017 16:55  |
|
XpertDBA99
Messages: 2
Registered: July 2017
|
Junior Member |
|
|
So why do they even provide the option of adding domain groups in on the Oracle Administration Assistant for Windows, if you can't use the domain groups to do Windows Authentication? I was assuming once you added those groups in as DB administrators that the members of that group could access the database specified.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
