| Trouble creating Users Via Web Front End [message #62383] |
Sun, 18 July 2004 22:36  |
Jason Brewster
Messages: 8
Registered: June 2004
|
Junior Member |
|
|
I'm having trouble creating user in a 9i database via web front end.
I use the following sql to create the user
strSQL="CREATE USER"""+strUser+"""PROFILE ""DEFAULT"" IDENTIFIED BY ""HELLO"" DEFAULT TABLESPACE ""DATA"" TEMPORARY TABLESPACE ""TEMP"" ACCOUNT UNLOCK"
I then execute another two sql statments to grant "connect" thus
strSQL="GRANT ""CONNECT"" TO "+strUser+""""
strSQL="ALTER USER """ +strUser+"""DEFAULT ROLE ALL"
Whenever I try connecting using the new users details, but get an error message that the server had problems accessing the LDAP directory service(ORA-28030).
I'm happy that the SQL is correect as I created the account that I wanted using Enterprise Console and coppied the SQL it produced. I'm assuming that there's something in the background that is not being triggered when creating the user via the web front end.
Can anyone tell me where I'm going wrong?
Thanks
Jason
|
|
|
|
|
|
| Re: Trouble creating Users Via Web Front End [message #62393 is a reply to message #62390] |
Mon, 19 July 2004 22:17  |
Jason Brewster
Messages: 8
Registered: June 2004
|
Junior Member |
|
|
I'm not sure if I'm using LDAP for authentication or not. How would I tell?
I have two sqlnet.ora files
C:ora9iasnetworkADMIN
C:ora9iasnetworkADMINSAMPLE
I'm guessing the first is the active file. This file has very little in it. I've pasted it below, maybe you can tell me if this is a redundant file or one being used.
# SQLNET.ORA Network Configuration File: C:ora9iasnetworkadminsqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = htcuadmin
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
Thanks
Jason
|
|
|
|
|
|
|
|
|
|
| Re: Trouble creating Users Via Web Front End [message #62420 is a reply to message #62419] |
Wed, 21 July 2004 03:50 |
Jason Brewster
Messages: 8
Registered: June 2004
|
Junior Member |
|
|
"ANO or OID"? You'll have to excuse my inexperience. I'm new to this and have no idea what they are.
I set up the database (9ias) and can administer it via the Enterprise Manager Standalone Console. I have no idea what kind of authentication is being used.
The web front end is asp.net (.aspx) pages. I'm able to connect, insert, delete, update and select without any problems.
If I create the user via the web page and I can then see it in the enterprise manager console but can't connect using that user even though I can see it in enterprise manager
Thanks
Jason
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
