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