Welcome Guest Search | Active Topics | Members | Log In | Register

Agilis Software Forum » SQL Server » SQL Server General » Minimum permission to attach / detach databases

Minimum permission to attach / detach databases Options · View
Previous Topic · Next Topic
Heiko Schuler
Posted: Wednesday, October 17, 2007 5:42:23 PM


Rank: Guest
Groups: Guest

Joined: 9/17/2007
Posts: 11,670
Points: -1,200
Date parsed: 17/10/2007 17:42:23
Date: Thu, 18 Oct 2007 00:42:23 -0700

Hi group,

I've got a problem determining permissions for users. I got one group
of users which only should have the abilitiy to attach / detach any
database to the SQL Server.
I just thought the SQL server wide user role dbcreator seems to be
sufficient for them but if I try to attach a database on which this
group does not have any permission within (its a database from an
external vendor), attaching the database fails.


Any hints on this?


Thanks,


Heiko
Back to top
 
Heiko Schuler
Posted: Wednesday, October 17, 2007 6:25:41 PM


Rank: Guest
Groups: Guest

Joined: 9/17/2007
Posts: 11,670
Points: -1,200
Date parsed: 17/10/2007 18:25:41
Date: Thu, 18 Oct 2007 01:25:41 -0700

> Can you elaborate a little bit?
Sure - I got one user which has the database role "dbcreator". When I
now try to attach a database, I got an error. the strange thing is - I
got 2 different depending using the GUI or T-SQL.

When I use the GUI, after selecting the mdf file, I got the following
error:
"User 'guest' does not have permission to run DBCC checkprimeryfile.
OK, this error message itself is clear because only members of the
sysadmin or server admin role can run DBCC commands. But why does the
GUI wants to run DBCC checkprimeryfile?

When I try to attach the database via T-SQL with sp_attach_db in Query
Analyzer, I got the following error:
"Unable to open the physical fiel <path to the mdf>. Operating system
error 5 (error not found).

Depending on the message error message above I first thougt it was a
permisson error on the file system. But if I put the user in the
sysadmin server role - everything works fine. So NTFS permission on
the file system is OK.

Heiko
Back to top
 
Uri Dimant
Posted: Thursday, October 18, 2007 11:57:13 AM


Rank: Guest
Groups: Guest

Joined: 9/17/2007
Posts: 11,670
Points: -1,200
Date parsed: 18/10/2007 11:57:13
Date: Thu, 18 Oct 2007 09:57:13 +0200

Heiko
Can you elaborate a little bit?
>but if I try to attach a database on which this
> group does not have any permission within (its a database from an
> external vendor), attaching the database fails.
>





"Heiko Schuler" <hschuler@gmail.com> wrote in message
news:1192693343.587584.291710@v29g2000prd.googlegroups.com...
> Hi group,
>
> I've got a problem determining permissions for users. I got one group
> of users which only should have the abilitiy to attach / detach any
> database to the SQL Server.
> I just thought the SQL server wide user role dbcreator seems to be
> sufficient for them but if I try to attach a database on which this
> group does not have any permission within (its a database from an
> external vendor), attaching the database fails.
>
>
> Any hints on this?
>
>
> Thanks,
>
>
> Heiko
>


Back to top
 
Users browsing this topic
Guest

Agilis Software Forum » SQL Server » SQL Server General » Minimum permission to attach / detach databases


Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

YAFPro Theme Created by Jaben Cargman (Tiny Gecko)
Powered by Yet Another Forum.net version 1.9.1.1 (NET v2.0) - 9/10/2007
Copyright © 2003-2006 Yet Another Forum.net. All rights reserved.
This page was generated in 0.097 seconds.