Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQLAgentReaderRole Expand / Collapse
Author
Message
Posted Tuesday, January 28, 2014 7:23 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 11:23 AM
Points: 2,691, Visits: 3,376
I want to prove to my colleagues that with SQLAgentReaderRole, a user can elevate their rights. I want to do this quickly before we open the door to developers and then have a hard time closing it. Anyone have any ideas? This is proof of concept people. Not a legitimate hack.

Thanks,

Jared
SQL Know-It-All

How to post data/code on a forum to get the best help - Jeff Moden
Post #1535691
Posted Wednesday, January 29, 2014 1:27 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 11:23 AM
Points: 2,691, Visits: 3,376
I guess it is not that bad a role to grant.

Thanks,

Jared
SQL Know-It-All

How to post data/code on a forum to get the best help - Jeff Moden
Post #1536094
Posted Wednesday, January 29, 2014 9:27 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
I dint get your question clearly, what do you think SQLAgentReaderRole can do to the users.

Regards
Durai Nagarajan
Post #1536154
Posted Wednesday, January 29, 2014 9:30 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
if you are slightly unhappy with changing user owned jobs and schedules , change the same to ta sysadmin user and give permission.

Regards
Durai Nagarajan
Post #1536155
Posted Wednesday, January 29, 2014 9:50 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 11:23 AM
Points: 2,691, Visits: 3,376
durai nagarajan (1/29/2014)
I dint get your question clearly, what do you think SQLAgentReaderRole can do to the users.
The role allows users to create jobs;I.e. not just a reader role.


Thanks,

Jared
SQL Know-It-All

How to post data/code on a forum to get the best help - Jeff Moden
Post #1536159
Posted Friday, January 31, 2014 12:09 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
yes i understand, how about a self made report with history details. i dont tink any such reader role available by default.



Regards
Durai Nagarajan
Post #1536649
Posted Friday, January 31, 2014 3:59 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:03 AM
Points: 6,194, Visits: 13,348
the reader role allows multi server job access over the user role, do they need this?
The users will only be able to edit jobs\schedules that they own, what is it you're concerned about?


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1536698
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse