MySQL Forums
Forum List  »  Microsoft SQL Server

"Read Anything" // "Change Nothing"
Posted by: Sloan H
Date: March 25, 2010 07:23AM

Below is a article and syntax for giving dvelopers "read anything" but "change nothing" rights on (in my case) productionn servers.

//Quote Article
http://tsql.trigonblue.com/Articles/GrantViewAnyDefinition/tabid/609/Default.aspx

GRANT VIEW ANY DEFINITION TO [MyDomain\Developers]
GRANT VIEW SERVER STATE TO [MyDomain\Developers]

As a database architect/developer I would like to see everything on all servers, but I do see a need to prevent me from being able to change things in production.
//End Article

.......

I'm trying to make a mysql transition, but this is a pretty hefty need.....because our mysql expertise is not "around the clock", so developers have to be able to find/locate any issues (problems with the data in the database more exactly). And need that type of ability (above) that my company has implemented for Sql Server.

........

So is there any equivalent rights granting in mysql that mimics the above?

BIG THANKS IN ADVANCE on this one!

Options: ReplyQuote


Subject
Written By
Posted
"Read Anything" // "Change Nothing"
March 25, 2010 07:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.