The Cache: Technology Expert's Forum
 
*
Welcome, Guest. Please login or register. December 05, 2008, 12:06:21 AM

Login with username, password and session length


Pages: [1]
  Print  
Author Topic: Setting Permissions  (Read 202 times)
perkiset
Olde World Hacker
Administrator
Lifer
*****
Offline Offline

Posts: 5229


:sniffle: Humor was so much easier before.


View Profile
« on: May 27, 2008, 09:30:30 AM »

OK, ran some tests this morning.

To open procedures and functions you don't need much... but to create a new one or save changes you'll need CREATE ROUTINE and ALTER ROUTINE.
To run a procedure from the command line, although I have not tested it yet because the command line is not working, you'll most certainly need EXECUTE.

To access Triggers, you will have to have the "Super" privilege.

In all cases, if you don't have the appropriate privileges, the IDE tells you what the problem is.
Logged

If I can't be Mr. Root then I don't want to play.
Pages: [1]
  Print  
 
Jump to:  

Perkiset's Place Home   Best of The Cache   phpMyIDE: MySQL Stored Procedures, Functions & Triggers
Politics @ Perkiset's   Pinkhat's Perspective   
cache
mart
coder
programmers
ajax
php
javascript
Powered by MySQL Powered by PHP Powered by SMF 1.1.2 | SMF © 2006-2007, Simple Machines LLC
Seo4Smf v0.2 © Webmaster's Talks


Valid XHTML 1.0! Valid CSS!