Re: SecurityAdmin server role

From: jaylou (jaylou_at_discussions.microsoft.com)
Date: 08/02/05 

Date: Tue, 2 Aug 2005 06:09:06 -0700

Thanks for the reply.

I do understand the diffent roles in the DB's. I have added the user in as
DB_AccessAdmin. I have tried to give all rights besides db_owner.

For some reason if I do not grant DB_Owner rights I can't set user
permissions.

Thanks agin,
Joe

"Hari Prasad" wrote:

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

Relevant Pages

  • Re: 1 user gets when "admin" in use - but no login/password prompt
    ... I hadn't thought of checking their user rights, ... ACCESS Secure Database with permissions... ... My Server Administrator... ... network operating system, what desktop operating systems? ...
    (microsoft.public.access.security)
  • Re: Error code = 4060
    ... divisional portals are running under a different app pool and identity than ... the corporate portal, and the identity of this pool, while having dbo rights ... portal's content database. ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: db_denydatawriter
    ... perhaps this also gives read write access on the database to this user? ... Resrictive permissions overrides in its own level. ... However, if she has sysadmin right, then she'll be able to modify that data. ... Is it possible she has some admin rights which override DenyWriter (though ...
    (microsoft.public.sqlserver.security)
  • Re: Complete Neophyte Question(s)
    ... No you cannot remove a login from the 'public' role. ... For rights to _use_ objects then the appropriate rights need to be granted ... GRANT SELECT ON dbo.Orders TO OrderViewers ... for a database that is supposed to be secured it is a bad idea ...
    (microsoft.public.sqlserver.security)
  • Re: SUUNTO Vyper PC i/f
    ... username and password. ... to enter the database password. ... I gained access to the data in Suunto v2 using it - but it will NOT allow ... have the rights to the program the DATA is MINE!! ...
    (uk.rec.scuba)