x

does not have permission to read meta data.

User does not have permission to run DBCC showfilestats for database . is the error while user try to see datbabase properties by right click.

which permission can give him access/rather any permission which is equal to dbowner

----below is udated,

so current situation is even i have given DBowner to check if is this the only situation to solve, user getting error like could not able to read meta deta.
more ▼

asked Nov 16, 2011 at 02:01 AM in Default

Sri 1 gravatar image

Sri 1
11 9 9 10

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

You have to be a member of the db_owner database role or a member of the sysadmin role to be able to run this command on a database.

EDIT:

[Your original question was about scripting out all objects of a database.][1] To do this, you have to have highly elevated permissions. Maybe it is possible to do so without assigning the user to the db_owner role, but I doubt it.

If you want to do something that requires elevated permissions, then you have to assign those permissions (even if only temporarily).

[1]: http://ask.sqlservercentral.com/questions/80709/generating-a-script-for-database-with-all-object
more ▼

answered Nov 16, 2011 at 02:16 AM

WilliamD gravatar image

WilliamD
25.9k 17 19 41

without giving any ownership is it not possible..? actually need is to fetch script for database with all object and user is getting error on seeing the properties as well. i have given view defination permission already.

but current error he is getting like could not read the meta data error.
Nov 16, 2011 at 02:28 AM Sri 1
@Sri, Thanks for making it a comment.
Nov 16, 2011 at 02:39 AM Usman Butt

@i have tried after giving DBowner role to that user, but now error get changed on error report and it stated " could not read the meta deta, have insufficient access"

what sud i do nw.
Nov 16, 2011 at 03:04 AM Sri 1

Whatever the first option is / does, the user running the wizard doesn't have sufficient permissions. AS I mentioned already, consider elevating the permissions for the period of scripting the database and then revoking those extra permissions afterwards.

The first option probably goes outside of the actual database to collect more information (maybe at the instance level or in system databases), being a db_owner of just the target DB will then not be enough.
Nov 16, 2011 at 04:25 AM WilliamD

William is saying they need to be in sysadmins role. Being able to script out your instance gives the user all of your intellectual property. If this is something they are allowed then go ahead.

Or you can get them to put in a request and you can script it out for them.
Nov 16, 2011 at 05:22 AM Blackhawk-17
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x24

asked: Nov 16, 2011 at 02:01 AM

Seen: 1437 times

Last Updated: Nov 16, 2011 at 02:45 AM