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.
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.] 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). :