PEAR Packages
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Codewalkers ForumsPHP RelatedPEAR Packages

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Codewalkers Forums Sponsor:
  #1  
Old August 14th, 2006, 04:11 PM
MRKisThatKid MRKisThatKid is offline
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Posts: 4 MRKisThatKid User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
MDB2 Manager CreateDatabase confusion

I'm trying to have MDB2 create a new database but i'm confused as to how it can be done. I've tried using CreateDatabase, and it does indeed create a database but it doesn't assign the currently logged in user any privileges, and once the script has finished the new database can no longer be access by the web app.

All this works if you use a root account but thats a little too much to ask of people wanting to use my web app.

Any ideas? Thanks

Reply With Quote
  #2  
Old August 14th, 2006, 04:46 PM
Anonymous Anonymous is offline
Registered User
Codewalkers God 35th Plane (22000 - 22499 posts)
 
Join Date: Apr 2007
Posts: 22,309 Anonymous User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 24
RE: MDB2 Manager CreateDatabase confusion

Ah, actually what I wrote previously is all nonsense.... I'll try again...

I'm trying to have MDB2 create a new database but i'm confused as to how it can be done.

In the context of a Web Application setup script...As far as I can figure out the process would have to be something like this...

1 Request the login/pass of the root account as well as a more restricted account for keeping permanently and using as the day-to-day database login.
2 Login with the root details and create the database and grant the day-to-day account access to the new database.
3 Disconnect as root and continue from then on as the day-to-day account.

My problem is, I can't find any function in the MDB2 package for controlling the grant tables. Or to do anything related to database users in fact.

Any Ideas?

Reply With Quote
  #3  
Old August 31st, 2006, 02:39 PM
Anonymous Anonymous is offline
Registered User
Codewalkers God 35th Plane (22000 - 22499 posts)
 
Join Date: Apr 2007
Posts: 22,309 Anonymous User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 24
RE: MDB2 Manager CreateDatabase confusion

correct, there is currently no way to manage user access rights via the MDB2 API

Reply With Quote
Reply

Viewing: Codewalkers ForumsPHP RelatedPEAR Packages > MDB2 Manager CreateDatabase confusion


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway
Stay green...Green IT