humpydumpy2000
IS-IT--Management
Hi all,
How am I going to create a user that would allowed only to create, delete and view their own databases but not the main administrator database?
Thanks a lot.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Create user, permissions
- Thread starter humpydumpy2000
- Start date
- Status
Hi all,
How am I going to create a user that would allowed only to create, delete and view their own databases but not the main administrator database?
Thanks a lot.
ChrisHirst
IS-IT--Management
GRANT ALL ON [database].* TO 'user@hostname';
Chris.
Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Never mind this jesus character, stars had to die for me to live.
Chris.
Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Never mind this jesus character, stars had to die for me to live.
- Status
