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.
[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).: h ttp://ask.sqlservercentral.com/questions/80709/generating-a-script-for-database-with-all-object