Post reply

reading through security principles

  • September 11, 2007 at 4:01 am

    #118589

    Im confused (no change there then )

    Can someone clarify this for me as its the little thingsa that bug me and this is one of them

    Are database users classed as sql principles in 2005 and if not why not (I think the answer is there not but Im unsure as to the rationale !)

    Thanks

     

    Si

  • September 11, 2007 at 4:35 am

    #732729

    There are different types of principals in SQL Server. There are server and database principals. (as in sys.database_principals and sys.server_principals)

    database users are part of the database_principal level.

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • December 18, 2007 at 6:33 am

    #760975

    One of those Eureka moments where having revisited the question and re-read your reply it makes perfect sense !

    thank you !

    kind regards

    ~si

Viewing 3 posts - 1 through 2 (of 2 total)

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