OAS 4.0.8 standard login prompt

OAS 4.0.8 standard login prompt

Post by John So » Sun, 31 Dec 1899 09:00:00



Hi all,

How does one get the standard LOGIN screen appearing
when running an application ? We've upgraded from 2.1
to OAS 4.0.8 but I can't seem to get our old PL/SQL application
running. It by-passes the login screen. Previously we entered our
usernames and passwords into Basic Users, Groups and Realms
etc. and the users would be prompted with a login screen
at application startup.

Thanks John.

 
 
 

1. different between NT login and standard login in SQLServer **

Hi

I created an standard login and user and followed theses steps and there was no problem
and at result my created table belongs to 'user1'.
but in 2th try when I wnated to create a windows NT login and followed the 2th steps there
was a problem for me.this problem is : it shows at last step that my table belongs to 'sa' not to 'urezvani' which
created this table!!!!!!  but in 1th try there's no problem and it shows the table 't113' belongs to 'user1'
so, what's wrong here?

1th try  ----->    with success

in Osql:

    exec sp_addlogin 'login1'
    exec sp_adduser 'login1','user1','db_owner'

in VB:

     Set con = CreateObject("adodb.connection")
     Set rs = CreateObject("adodb.recordset")
     Set cmd = CreateObject("adodb.command")

   ' Connect to Database
    con.ConnectionString = "driver={SQL Server};server=parskhazar3;uid=login1;pwd=;database=productstock"
         con.Open

     sql1 = "create table t113(f1 char(1),f2 char(2));"
    cmd.ActiveConnection = con
    cmd.CommandText = sql1
    cmd.CommandType = adCmdText
    cmd.Execute

in Osql:
    exec sp_tables 't113';

   table_owner     ..........
  --------------------
    user1

2th try -----------> not my excepted result!!!!

in Osql:

    exec sp_addlogin 'khazar2.com\rezvani'
    exec sp_adduser 'khazar2.com\rezvani','urezvani','db_owner'

   successed

in VB:

     Set con = CreateObject("adodb.connection")
     Set rs = CreateObject("adodb.recordset")
     Set cmd = CreateObject("adodb.command")

   ' Connect to Database
    con.ConnectionString = "driver={SQL Server};server=parskhazar3;uid=khazar2.com\rezvani;pwd=;database=productstock"
         con.Open

     sql1 = "create table t113(f1 char(1),f2 char(2));"
    cmd.ActiveConnection = con
    cmd.CommandText = sql1
    cmd.CommandType = adCmdText
    cmd.Execute

(  **** successed******)

in Osql:
    exec sp_tables 't113';

   table_owner     ..........
  --------------------
    sa

Thanks

2. Stored Procs - Opinions Please

3. different between NT login and standard login in SQLServer**

4. Timeout Expired on server connection in EM

5. Question: SQL Server Login Prompt

6. OpenMFG: PostgreSQL-backed ERP for small manufacturers

7. Access 97 / SQL Server: Login Prompts when query is run twice

8. Is oinstall group strictly necessary?

9. Unwanted SQL Login Prompt

10. ODBC Prompts user for login details rather than reporting error

11. Double Login Prompt

12. Setting option to prompt SQL for login box

13. Access 95 / SQL Server: Login Prompts