Problem with user created

Hi,
I created a user (from EM) and give him only access to a test database and 3
extended sp in the master db, however, when I login with the username and pas
in Query Analyzer I can access app the sp, extended sp, tables in the master
database, tempdb and the msdb. I even see them listed in the database objects
section. When I go to users under tempdb and msdb I don't see the user there
whent going on here. I only want the user to access and see the test database
and the few extended sp in the master database.
Thanks
All users can access master, msdb and tempdb via the guest user in those
databases. Access to master and tempdb via the guest user is essential for
the proper functioning of any user login. Msdb access is not strictly
essential, but users by default have permissions to create jobs and DTS
Packages, among others, and jobs and DTS Packages are stored in msdb
Jacco Schalkwijk
SQL Server MVP
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:4AA98274-740F-4F89-8178-CED99DD1DCF0@.microsoft.com...
> Hi,
> I created a user (from EM) and give him only access to a test database and
> 3
> extended sp in the master db, however, when I login with the username and
> pas
> in Query Analyzer I can access app the sp, extended sp, tables in the
> master
> database, tempdb and the msdb. I even see them listed in the database
> objects
> section. When I go to users under tempdb and msdb I don't see the user
> there
> whent going on here. I only want the user to access and see the test
> database
> and the few extended sp in the master database.
> Thanks
|||It is probably due to the fact that the guest user is enabled in those
databases.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:4AA98274-740F-4F89-8178-CED99DD1DCF0@.microsoft.com...
Hi,
I created a user (from EM) and give him only access to a test database and 3
extended sp in the master db, however, when I login with the username and
pas
in Query Analyzer I can access app the sp, extended sp, tables in the master
database, tempdb and the msdb. I even see them listed in the database
objects
section. When I go to users under tempdb and msdb I don't see the user there
whent going on here. I only want the user to access and see the test
database
and the few extended sp in the master database.
Thanks
|||Thanks Guys!
"Chris" wrote:

> Hi,
> I created a user (from EM) and give him only access to a test database and 3
> extended sp in the master db, however, when I login with the username and pas
> in Query Analyzer I can access app the sp, extended sp, tables in the master
> database, tempdb and the msdb. I even see them listed in the database objects
> section. When I go to users under tempdb and msdb I don't see the user there
> whent going on here. I only want the user to access and see the test database
> and the few extended sp in the master database.
> Thanks