Re: User added via group membership

anonymous_at_discussions.microsoft.com
Date: 07/21/04 

Date: Wed, 21 Jul 2004 08:56:04 -0700

Thanks, but I think you misunderstood my question.
>-----Original Message-----
>Hi,
>
>First you have add the Windows user to Access the SQL
server.
>
>EXEC sp_grantlogin 'domain\windowslogin'
>
>After that create a database user to access the database.
>
>use <dbname>
>go
>EXEC
sp_grantdbaccess 'domain\windowslogin', 'username_in_databa
se'
>
>After this grant execute previlage to this user for that
procedure
>
>GRANT EXECUTE ON <procedure> to <user_name_in_database>
>
>
>Registering in Enterprise manager:
>
>1. Login to OS using that domain user
>2. Right click regisrter and use windows authentication
>
>Now it will allow you to register the server
>
>Thanks
>Hari
>MCDBA
>
>
>
>"Colleen" <anonymous@discussions.microsoft.com> wrote in
message
>news:140901c46f2c$65fa6790$a401280a@phx.gbl...
>> I just stumbled upon something I thought was odd.
>>
>> I created a stored procedure and issued 'GRANT EXECUTE
ON
>> <procedure> to <domain\windowslogin>. The login did not
>> exist on the server but it added a user into the
>> database 'via group membership'. The user later tried
to
>> register the server in Enterprise Manager and of course
>> got an error that he didn't have a login. Why would it
>> allow the GRANT if it's not a valid login? How would
they
>> be able to execute the procedure without a valid login?
>>
>>
>
>
>.
>

Relevant Pages

  • Re: Help me!
    ... When you're exploring the data in BI Development Studio, the connection is ... to the database pointed to by your data source, you'll be able to see the ... However, when you deploy to an AS server, the connection is ... Or you can set it up to impersonate a specific Windows user ...
    (microsoft.public.sqlserver.datamining)
  • RE: Exporting data to another server
    ... On the Choose a Data Source page I have as the ... server, and the 'Use Windows Authentication' radio button ... The database is LynxServer. ... LynxServer is the valid login on the remote ...
    (microsoft.public.sqlserver.security)
  • Re: Table permissions: No matter what I set all users have full access?
    ... I have created a new Windows user the ... logged on to another PC as that user and can still access the database with ... The new user does not have a login on the server and is ... I even created a login for the user and denied SELECT permissions on various ...
    (microsoft.public.access.adp.sqlserver)
  • Re: User added via group membership
    ... First you have add the Windows user to Access the SQL server. ... After that create a database user to access the database. ... EXEC sp_grantdbaccess 'domain\windowslogin', 'username_in_database' ... > allow the GRANT if it's not a valid login? ...
    (microsoft.public.sqlserver.security)
  • Re: Database permissions
    ... Use the below system procedure to give the windows user /group to access sql ... Go to the database which user need access. ...
    (microsoft.public.sqlserver.programming)
Quantcast