Re: Add Global Group to Database

From: Joachim Hofmann (joachim.hof_at_gmx.de)
Date: 05/13/03

  • Next message: Kristofer Gafvert: "Re: Beginner question." 
    Date: Tue, 13 May 2003 11:24:28 +0200

    OK. It seems one has to open explicit a new server/database connection by Query Analyzer. Just sending the Query again does not work.

    if is_member('role_JHTestrolle') = 0
    print 'Du bist *nicht* in Rolle role_JHTestrolle'
    else if is_member('role_JHTestrolle') = 1
    print 'Du bist in in Rolle role_JHTestrolle'
    else if is_member('role_JHTestrolle') IS NULL
    print 'Die Rolle role_JHTestrolle gibt es nicht'

    Joachim Hofmann schrieb:
    >
    > Hello,
    >
    > I am trying out several user access drafts in SQL Server 2000.
    >
    > One way I thougt this has to work, is:
    >
    > - Putting a particular Windows domain user into a global group
    > - Add this global group to SQL Server
    > - grant Access to a particular database
    >
    > But it doesnt work, when I execute something in Query Analyzer, I get:
    >
    > The Server user 'Domain\User' is not a valid User in the Database <particular database>
    >
    > Are there any pitfalls? What may I have forgotten?
    > Any Hints?
    >
    > Thank You very much
    >
    > Joachim

  • Next message: Kristofer Gafvert: "Re: Beginner question."

    Relevant Pages