Re: SecurityAdmin server role

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 08/01/05

  • Next message: Hari Prasad: "Re: Login Question" 
    Date: Tue, 2 Aug 2005 03:00:38 +0530

    Hi,

    Add that login to that partcular database as a database user and assign
    database fixed role db_accessadmin.

    See the article for more info:-

    http://www.databasejournal.com/features/mssql/article.php/1479561

    Thanks
    Hari
    SQL Server MVP

    "jaylou" <jaylou@discussions.microsoft.com> wrote in message
    news:39C74799-99BD-4877-9E6B-12602AAE6719@microsoft.com...
    > If a user has SecurityAdmin Server rights shouldn't that person be able to
    > add new Database users to the individual DB's? I can log in as my
    > Security
    > Admin and add new logins to the server but I can't add that same user to
    > an
    > databases.
    >
    > I tried giving the SecAdmin, SecAdmin rights to the DB's but that didnt
    > help, I added him to the owners group of the DB and that also didnt help.
    > Any ideas?
    >
    > Thanks,
    > Joe

  • Next message: Hari Prasad: "Re: Login Question"

    Relevant Pages

    • Re: Install MSDE w/ MSDE Depl.Toolkit. What permissions when using Win Auth?
      ... I created a login using Enterprise Manager on SQL Server on my server. ... Database Access tab I ticked the tick box for the database that I ... Now when my user installed the MSDE database on his machine locally, ...
      (microsoft.public.sqlserver.msde)
    • Re: SQL Server 2005 Express Remote connection
      ... I have also deleted the login for Fred from the list of users for my ... So Fred no longer exists as a login or as a user in the SQL Server setup. ... the database? ...
      (microsoft.public.sqlserver.server)
    • Re: Installation OK, but cant connect
      ... > created an access database. ... SQL Server authentication is "client" independent.... ... connections or SQL Server authenticated connections... ... which authenticate user's login at the windows login step... ...
      (microsoft.public.sqlserver.msde)
    • Re: Moving a database to another server
      ... onto a server at home. ... The database has a user that has public, db_owner, ... SQL Server login or a Windows login. ...
      (microsoft.public.sqlserver.server)
    • Re: Setting up Linked server to MsAccess
      ... At the server level I have added my windows user group ... At the database level I have added my Server login ...
      (microsoft.public.sqlserver.security)