Hi all,
If I want to create Amin user in SQL and give that user all permissions like
sa login.
How would I do that without having to go into each database and creating
roles
or checking permissions for each task?
thanks
GVYou can add the user to the sysadmin fixed server role.
-Sue
On Fri, 11 Feb 2005 17:22:25 -0500, "gv" <viatorg@.musc.edu>
wrote:
>Hi all,
>If I want to create Amin user in SQL and give that user all permissions lik
e
>sa login.
>How would I do that without having to go into each database and creating
>roles
>or checking permissions for each task?
>thanks
>GV
>|||Thanks
GV
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:q6lq01d8hitujnvbqovus510hfgqo6m00k@.
4ax.com...
> You can add the user to the sysadmin fixed server role.
> -Sue
> On Fri, 11 Feb 2005 17:22:25 -0500, "gv" <viatorg@.musc.edu>
> wrote:
>
>
No comments:
Post a Comment