Oracle User Account

[Lemox]

Hi,

How can I use the Oracle user's login and password on the Oracle server ?
I don't want these information to be stored in a table... (security)

Thanks
Lemox

 

[Bastien]

Need to use the oracle password file and create a user for each. Best to create a general role and grant users that role to limit the amount of admin to do.

"create role rolename grant [list of priviledges]"

&quot;Create user username identified by <some pass word>&quot;

http://www.dba-oracle.com/art_builder_grant_sec.htm

hth



Bastien

Any one have a techie job in Toronto, I need to work...being laid off sucks!

 

[Lemox]

Ok, thanks... but I know how it works within Oracle ;-)
I just would like to know how I can use the Oracle accounts FROM VB.

Thanks
Lemox

 

[Bastien]

Oh, okay

I create a connect function and the name and password used give that connection the priviledges attached to the user.

Public Sub DBOpen()

conn = "Provider=MSDASQL.1;" & _
"Data Source=MS" & txtServer.Text & ";Password=*****;User ID=******;"
'oracle
Set iOraConn = New ADODB.Connection
'MsgBox conn
iOraConn.ConnectionString = conn

iOraConn.Open
Set iOraData = New ADODB.Recordset
      iOraData.CursorType = adOpenKeyset
      iOraData.LockType = adLockOptimistic
      'iOraData.Source = sql
Set iOraData.ActiveConnection = iOraConn

If Err.Number <> 0 Then
    MsgBox &quot;There was an error connecting to the database. Ending program.&quot;
    Call KillXL
    Set iOraConn = Nothing
    Set iOraData = Nothing
    End
End If


End Sub

Bastien

Any one have a techie job in Toronto, I need to work...being laid off sucks!