OraFAQ Forum: General » connect as sydba in asp!!??

Home » Other » General » connect as sydba in asp!!??

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

connect as sydba in asp!!?? [message #230675]

Thu, 12 April 2007 10:14

cefb
Messages: 56
Registered: March 2007

Member

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

Report message to a moderator

Re: connect as sydba in asp!!?? [message #230685 is a reply to message #230675]

Thu, 12 April 2007 10:35

Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: connect as sydba in asp!!?? [message #230691 is a reply to message #230675]

Thu, 12 April 2007 10:42

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".

Report message to a moderator

Re: connect as sydba in asp!!?? [message #230699 is a reply to message #230691]

Thu, 12 April 2007 10:58

Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: connect as sydba in asp!!?? [message #230704 is a reply to message #230675]

Thu, 12 April 2007 11:05

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

Report message to a moderator