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 ««12

Reporting Services Makes Server Support Easier Expand / Collapse
Author
Message
Posted Wednesday, April 18, 2007 2:12 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 10, 2014 7:24 AM
Points: 1,060, Visits: 874

Yes I thought so too.

However:

select user_name(grantee_principal_id), permission_name, state_desc from sys.database_permissions where major_id = object_id('xp_fixeddrives')

tells me that public has exec granted.

The following:

create login bob
WITH PASSWORD = 'b0b',
CHECK_POLICY = OFF

master..sp_adduser bob
grant exec on xp_fixeddrives to bob
Then tells me bob has the rights on it.
But if you log in as bob, and run xp_fixeddrives it runs fine, but doesn't give you any (ok, me and I think you) results. Which is odd quite frankly.
 
I haven't managed to figure out yet exactly what it does need, but I don't want to be connecting reporting services as sa...
 
I am hoping someone may be able to point at a setting/permission perhaps that handles this.
 
Cheers.
 
 



Post #359158
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse