Home » Other » General » connect as sydba in asp!!??
connect as sydba in asp!!?? [message #230675] Thu, 12 April 2007 10:14 Go to next message
cefb
Messages: 56
Registered: March 2007
Member
hi Razz

is there any way of connecting to oracle db as sysdba in a asp?
i am using the connection string

Provider=OraOLEDB.Oracle;Data Source=;User Id=;Password=;PLSQLRSet=1;



Thanks
Re: connect as sydba in asp!!?? [message #230685 is a reply to message #230675] Thu, 12 April 2007 10:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know the answer but I think the real question is:
Do you need to connect as SYSDBA with asp?

SYSDBA is only for db maintenance and I doubt someone do db maintenance with asp.

Regards
Michel
Re: connect as sydba in asp!!?? [message #230691 is a reply to message #230675] Thu, 12 April 2007 10:42 Go to previous messageGo to next message
cefb
Messages: 56
Registered: March 2007
Member
i need that for only one step because i need to create two or three
tables under sys user to use them like "system tables".
Re: connect as sydba in asp!!?? [message #230699 is a reply to message #230691] Thu, 12 April 2007 10:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, never ever create anything in SYS schema.
SYS is Oracle proprietary.
When you patch or upgrade SYS schema maybe modified, what happens to your objects? Nobody knows.
Create your own schema to store your objects.

Regards
Michel
Re: connect as sydba in asp!!?? [message #230704 is a reply to message #230675] Thu, 12 April 2007 11:05 Go to previous messageGo to next message
cefb
Messages: 56
Registered: March 2007
Member
but some how i am going to need to make a sys connection i think, because that tables will be installed in other database i don't know i then i will create "my user" for the tables
Re: connect as sydba in asp!!?? [message #230707 is a reply to message #230704] Thu, 12 April 2007 11:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, you just need a DBA, you don't to be SYSDBA.

Regards
Michel
Re: connect as sydba in asp!!?? [message #230708 is a reply to message #230675] Thu, 12 April 2007 11:09 Go to previous message
cefb
Messages: 56
Registered: March 2007
Member
ok then.

thanks for your time.

Previous Topic: Can u tell me????
Next Topic: software needed
Goto Forum:
  


Current Time: Mon Dec 05 15:21:23 CST 2016

Total time taken to generate the page: 0.14557 seconds