Re: Permissions in SQL Server 2005
- From: "Rick Byham, MSFT" <rickbyh@xxxxxxxxxxxxx>
- Date: Fri, 24 Jul 2009 09:00:38 -0700
When you have the View Designer window open, press F4 to open the property
window. There is a property called Schema. That box probably contains the
name of a schema that you don't have permission to use, or maybe even a
schema that doesn't exist. At any rate, try changing it to a schema that you
know you have permissions with.
--
Rick Byham, MSFT
(Implies no warranty or rights)
"Juan Manuel Porras Gálvez"
<JuanManuelPorrasGlvez@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:95311AB9-077A-468D-9538-3B25DA60876C@xxxxxxxxxxxxxxxx
Why are appearing this error when we're going to create a view in SQL
Server
2005?.
"Property DefaultSchema is not available for Database ... "
Now, we've created a database role function named "A" and we've added a
windows group to this one. "A" has got permission to connect and create
(only) views in database "X".
What's the cause to throw that error?. Could we solve that situation?. Are
there any document to publish that error is a "bug" in SQL Server 2005.
Thanks very much,
Juanma.
.
- References:
- Permissions in SQL Server 2005
- From: Juan Manuel Porras Gálvez
- Permissions in SQL Server 2005
- Prev by Date: Re: WSUS connection problem to SQL Server 2008
- Next by Date: Re: Problems with Database Permissions on SQL 2008
- Previous by thread: Re: Permissions in SQL Server 2005
- Index(es):
Relevant Pages
|
