Forums

My experience is that won't work including your 'super user' group and desire to have those users act as 'sa' but others will probably have more detailed responses..  

You will be constrained by the business logic when performing SQL tasks regarding users and access regardless of your underlying permissions.  I have never seen what you are trying to do work.

Best of luck on this.

Thanks Tim, that was what I suspected.  I find it odd that my 'super user' is able to do most everything, with this one exception.  I wonder what the logic is behind that?  It seems to me that if the ability to create a 'super user' exists, which it does, why would they limit this one functionality?  I would love to hear from Microsoft on that.

Hi Dana,

Thanks for taking the time to reply.  Given where we are now with SQL as the GP DB of choice I would think they wish they engineered this differently but at the time, certainly at the time I started with the product,. it was a product which had database Independence and ran on quite a few DB products including the MacIntosh.  At the time MS-SQL was just a next gen of the sybase product and itself (don't remember the version, I think SQL 4.0) quite a pain in the a.. to work with.  Things got much better with SQL 5 but the admin functions really haven't changed as they needed to be platform independent.