473,396 Members | 1,784 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

restricted rights for admin: only create/drop db and grant options on new db

hi,

is there a way to set up an user, how only have restricted admin
rights on mysql server. this user only should be able to create DBs
(and drop them) and set grants on this new DB.
i think with the standard mysql-privileges this can't be done.
- when a user has the drop-priv he can drop ALL DBs in the server.
- when a user has grant priv he can grant and revoke on all DBs...

we have setup the root with a secret password, and want to provide a
simple api for our developer so that they can create own databases and
set privs for this new DBs... with the standard commands the problem
is, that the password is not secret: "mysql -u root -p secret".

think this is only possible in writing a c-programm which uses
internal encryption for the password...

any other suggestions?

thanxs

markus
Jul 20 '05 #1
0 1181

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Alex Prokhorov | last post by:
Hello all! In my project I need to grant different users different levels of access to the features of the program. It is clear for me how to do it in case of simple allowed/denied access to the...
0
by: Jeff McKeon | last post by:
I have a need to get data from the db that requires me to=20 1) do a select and create a new table with the results=20 2) run a query against that new table=20 3) drop the new table=20 I have...
0
by: Engwar | last post by:
I have a web application. We have two users in the db. One for the standard website user who has only read access to the db. The other is an admin user that has full access so I can create, alter...
3
by: jean-dot-paul-at-opelwilly-dot-com | last post by:
Hello all, I have two different applications where my application wants to do something the logged user has not the rights to: 1) Change a HKEY_LOCAL_MACHINE key value. The user has only...
11
by: AnhTai | last post by:
Hi all, I've just installed MySQL 5.0 on my sun box (runing Solaris 10, install from blastwave). This is my first time with MySQL so I don't have any exp with it. I have some troubles as: -...
1
by: Alexander Weiner | last post by:
Hello, I have coded a program to change the IP-Adress Settings on a windows xp workstation. Works with an admin account without problems. Now I like to give some Users the program so that they...
8
by: peteh | last post by:
Hi All; I have what I hope is a simple environmental problem. I have some SQL that creates a VERY simple procedure. When the create is executed from Quest (from a Windows client) - no problem. As...
2
by: masri999 | last post by:
I have a requirement in SQL 2005 in Development database 1. Schema dbo owns all objects (tables,views,SPs,UDFs etc) . 2. Only DBA's ( who are database owners ) can create, alter tables ....
7
by: buzzluck68 | last post by:
Hello, I have an in house application that we developed, but everyone who needs to use the program are not allowed to be local admins on their PCs. I was wondering if there was a way to code...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.