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 Rhinorhino 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

Status
Not open for further replies.

humpydumpy2000

IS-IT--Management
Joined
Aug 18, 2016
Messages
30
Location
PH

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.

 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top