Raised This Month: $51 Target: $400
 12% 

Possible to have 2 databases with separate logins?


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Lt Llama
Senior Member
Join Date: Aug 2004
Old 03-05-2006 , 04:28   Possible to have 2 databases with separate logins?
Reply With Quote #1

Is it by default possible to have 2 logins and 2 passwords for sql access?
What would be the best way to solve it if not? Making a sql2.cfg, change cvar names and add the new login and pw for that database and change the plugins to use those?

I want this to be able to give another person access to the second db, but not the first.

sql.cfg

Code:
amx_sql_host	"127.0.0.1"
amx_sql_user	"user1"
amx_sql_pass	"password1"
amx_sql_db	"database1"
amx_sql_table	"amxx"
sql2.cfg

Code:
amx_sql2_host	"127.0.0.1"
amx_sql2_user	"user1"
amx_sql2_pass	"password2"
amx_sql2_db	"database2"
Lt Llama is offline
Silver Dragon
Veteran Member
Join Date: Jan 2005
Location: Chicago, Illinois
Old 03-05-2006 , 08:23  
Reply With Quote #2

No, I don't think that is possible.
Silver Dragon is offline
Send a message via AIM to Silver Dragon Send a message via MSN to Silver Dragon Send a message via Yahoo to Silver Dragon
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 01:40.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode