Re: About logins and roles
- From: "Tom Moreau" <tom@xxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 27 Aug 2007 22:09:31 -0400
Be sure that you did not add the login to any server-level groups. That may
be why you have permissions in all DBs.
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Henry" <henry@mobile> wrote in message
news:899B40D2-3309-4515-8F25-6BE45F3E9F9D@xxxxxxxxxxxxxxxx
Hi all expert,
I have create a logins called dbadmin
in what way can i restrict the logins to be able to access to a certain
database, or even certain tables inside database?
i have checked the security grid for accessing only certain database, such
as I checked the checkbox northwinds only, but finally i can gain access to
all db.
how to set exactly? please advise. and thanks in advance
.
- Prev by Date: in sql server is it possible to get the amount of memory used by a stored procedure? e.g. memory usage statistics per stored procedure?
- Next by Date: Re: in sql server is it possible to get the amount of memory used by a stored procedure? e.g. memory usage statistics per stored procedure?
- Previous by thread: in sql server is it possible to get the amount of memory used by a stored procedure? e.g. memory usage statistics per stored procedure?
- Next by thread: Re: About logins and roles
- Index(es):
Relevant Pages
|
