Thread: Insert DB users by script/code
-
March 22nd, 2009, 02:50 PM #1Member
- Join Date
- Mar 2005
- Posts
- 93
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!!!
-
March 22nd, 2009, 02:55 PM #2
If you can do it manually it can be done with a script.
"The problem with quotations on the internet is that the sources are hard to verify" - Abraham Lincoln
-
March 22nd, 2009, 03:02 PM #3Member
- Join Date
- Mar 2005
- Posts
- 93
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,
-
March 22nd, 2009, 03:35 PM #4
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."The problem with quotations on the internet is that the sources are hard to verify" - Abraham Lincoln
-
March 23rd, 2009, 02:50 PM #5
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).
-
March 23rd, 2009, 02:59 PM #6
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)."The problem with quotations on the internet is that the sources are hard to verify" - Abraham Lincoln
-
March 23rd, 2009, 06:44 PM #7Member
- Join Date
- Mar 2005
- Posts
- 93
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...
-
March 23rd, 2009, 08:08 PM #8
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.
-
March 23rd, 2009, 08:23 PM #9
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.
"The problem with quotations on the internet is that the sources are hard to verify" - Abraham Lincoln
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Similar Threads
-
"insert disk into E:
By david.stewart in forum Storage RelatedReplies: 2Last Post: August 1st, 2008, 05:09 PM -
HELP!! INSERT BOOTABLE MEDIA?
By shybajan4u in forum Technical SupportReplies: 3Last Post: October 19th, 2005, 03:17 PM -
[FaDChatThur28] TT is... (insert word)
By vikeor in forum Distributed ComputingReplies: 43Last Post: July 29th, 2005, 05:24 PM -
IE users, don't be shown up by those cool Mozilla users (your own TechIMO sidebar!)
By OuTpaTienT in forum IMO CommunityReplies: 28Last Post: July 25th, 2002, 09:31 PM



LinkBack URL
About LinkBacks



Reply With Quote

What? WHAT!?? No, no, no!
Is It Just Me? v233893843