How to work with result set from exec in a stored procedure?

Question

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

schwarz Old Hand Points: 368 More actions · Answer 1

I don't know, if it is a good idea to assign all my users to SYSADMIN role? Isn't it the same bad idea like the sa stuff?

Is there a way to restrict the rights of SYSADMIN?

Isn't there a way to allow 'normal users' to run very specific issues, normaly done by SYSADMINs?

I think, its a matter of principle, isn't it?

David.Poole SSC Guru Points: 76035 More actions · Answer 2

Absolutely. There should be very few SysAdmins.

You can assign owners to jobs and therefore sysadmin role is not needed.

Provided your user exists within MSDB they can use sp_Start_job etc, but only on their own jobs.

schwarz Old Hand Points: 368 More actions · Answer 3

Many thanks for your discussion with me!

I have got nearly the same problem as at the start of this threat. But now my understanding of the background details is much better. 😉

Thanks a lot,

Thilo

psullivan SSChasing Mays Points: 604 More actions · Answer 4

Yes you'll need every column and in similar/same datatypes as well.