"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!
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.