home hardware prices news articles forums photos user reviews
Go Back   Tech Support Forums - TechIMO.com > PC Hardware and Tech > Webmastering and Programming
Ask a Tech Support Question (free)!

Insert DB users by script/code

Reply
Get bargains at  »  Dealighted.com
 
Thread Tools Search this Thread
Currently Active Users: 1645
Discussions: 200,924, Posts: 2,379,112, Members: 246,290
Old March 22nd, 2009, 03:50 PM   Digg it!   #1 (permalink)
Member
 
Join Date: Mar 2005
Posts: 87
Red face
Insert DB users by script/code

Hello all

I am not sure if this can be done...

Can you insert a DBO or DBA (database user/admin) by scripts or visual basic code? Can these users be created like this?

Thank you for your smart answers!!!
Crisstina is offline   Reply With Quote
Old March 22nd, 2009, 03:55 PM     #2 (permalink)
SoMuchAnime-SoLittleTime
 
EXreaction's Avatar
 
Join Date: Aug 2003
Location: Plymouth, WI
Posts: 14,982
Blog Entries: 1
Send a message via MSN to EXreaction
If you can do it manually it can be done with a script.
__________________
My photography: Flickr

Lithium Studios - phpBB3, PHP, and Web Development
EXreaction is online now   Reply With Quote
Old March 22nd, 2009, 04:02 PM     #3 (permalink)
Member
 
Join Date: Mar 2005
Posts: 87
Thank you for your reply!

That's what I think but haven't been able to pull it.

Do you have an idea on how to ?

Thank you,
Crisstina is offline   Reply With Quote
Old March 22nd, 2009, 04:35 PM     #4 (permalink)
SoMuchAnime-SoLittleTime
 
EXreaction's Avatar
 
Join Date: Aug 2003
Location: Plymouth, WI
Posts: 14,982
Blog Entries: 1
Send a message via MSN to EXreaction
All you really need to do is setup the script to connect to the database and then run the SQL queries you need to add the user/admin.

I've never worked with databases through visual basic, so I can't tell you how. There are probably tons of tutorials if you search through google though.
EXreaction is online now   Reply With Quote
Old March 23rd, 2009, 03:50 PM     #5 (permalink)
Caveat Emptor
 
Rootstonian's Avatar
 
Join Date: Mar 2005
Location: Out of my mind
Posts: 3,241
Send a message via AIM to Rootstonian
That could depend on the interface too. If it's done via some type of web page or program or application, you have no idea (or maybe you do) what tirggers or procedures can be firing off in the background. A script will not be able to duplicate this (e.g. creating a hash value for a row entry).
Rootstonian is offline   Reply With Quote
Old March 23rd, 2009, 03:59 PM     #6 (permalink)
SoMuchAnime-SoLittleTime
 
EXreaction's Avatar
 
Join Date: Aug 2003
Location: Plymouth, WI
Posts: 14,982
Blog Entries: 1
Send a message via MSN to EXreaction
If a different script is currently being used to insert the data you'd of course have to figure out exactly what and how it is inserting the data as well.

If a different script is inserting it you can still duplicate it as long as you know what things are happening with the data, like if a password is being hashed with md5 or something (which BTW is a very bad idea to use MD5 alone for passwords).
EXreaction is online now   Reply With Quote
Old March 23rd, 2009, 07:44 PM     #7 (permalink)
Member
 
Join Date: Mar 2005
Posts: 87
So...

I know I can add rows to a table I created. And I know how to do that.

BUT...

Can I add rows to a system database? not one I created but those that are managed by the server? like "sa" user...
Crisstina is offline   Reply With Quote
Old March 23rd, 2009, 09:08 PM     #8 (permalink)
Caveat Emptor
 
Rootstonian's Avatar
 
Join Date: Mar 2005
Location: Out of my mind
Posts: 3,241
Send a message via AIM to Rootstonian
Probably not. Depends on who's doing secuitry on the database. That person would grant SELECT, INSERT, DELETE etc. access on any given table. And usually a "system" table would not be updated by a user.
Rootstonian is offline   Reply With Quote
Old March 23rd, 2009, 09:23 PM     #9 (permalink)
SoMuchAnime-SoLittleTime
 
EXreaction's Avatar
 
Join Date: Aug 2003
Location: Plymouth, WI
Posts: 14,982
Blog Entries: 1
Send a message via MSN to EXreaction
If you setup the server to accept incoming connections from your IP address (by default, database systems should only accept local requests from the same machine for security) and have access to a user who has permission to insert rows then it should work.
EXreaction is online now   Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
"insert disk into E: david.stewart Storage Related 3 August 22nd, 2008 07:56 AM
HELP!! INSERT BOOTABLE MEDIA? shybajan4u Technical Support 3 October 19th, 2005 04:17 PM
[FaDChatThur28] TT is... (insert word) vikeor Distributed Computing 43 July 29th, 2005 06:24 PM
INSERT missing packetjunkie Hot Deals - Found by You 1 March 10th, 2004 04:29 PM
IE users, don't be shown up by those cool Mozilla users (your own TechIMO sidebar!) OuTpaTienT IMO Community 28 July 25th, 2002 10:31 PM


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Most Active Discussions
Is It Just Me? (2859)
Obama the Muslim (14)
California Passes Anti-Flat-HDTV Le.. (39)
Is the PSU I received dead? (10)
windows vista security holes (9)
Foreign voltage (10)
HIS HD5770 graphic card question (15)
Print spooler problem (13)
Install XP pro and a Vista laptop ?.. (9)
Dept. of HS: NSA 'Helped' Develop V.. (15)
A good PSU? (10)
New Computer wont recognize XP disc (7)
Ideal cheap graph card for PC-Gamin.. (15)
EVGA 9800 gtx help with finding a g.. (8)
Recent Discussions
Optical Audio A-B Switch (0)
windows vista security holes (9)
Fire in DVD (0)
radeon x850xt platinum & shader 3 (2)
The NTDVM CPU has encountered an ille.. (24)
[F@H SPAM 11/16/09] ! 1/2 months to r.. (34)
Wireless speakers for PC? (11)
Print spooler problem (13)
Help getting around port 80 for camer.. (2)
Display shows 3x5 inch in middle of s.. (3)
monitor will not turn on at all, (1)
World's largest Monopoly Game using G.. (331)
Foreign voltage (10)
FiOS modem/router interfering with ne.. (7)
Browsers wont load websites (2)
Virus Doctor Popup? (1)
Dept. of HS: NSA 'Helped' Develop Vis.. (15)
Install XP pro and a Vista laptop ?? (9)
EVGA 9800 gtx help with finding a goo.. (8)
Modern Warfare For the PC (32)
Problem with speed step/turbo boost? (1)
Modern Warfare 2: Who Bought It? (61)
SIS 740 and Widescreen (8)
Baffling Problem with my CPU/MoBo's. .. (0)
HIS HD5770 graphic card question (15)


All times are GMT -4. The time now is 11:11 PM.
TechIMO Copyright 2009 All Enthusiast, Inc.



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28