i have created a login by using the following script
>create login xxxxxx with password ='yyyyy',check_policy=off,check_expiration=off ----for creating
>deny view any database to xxxxxx ----to deny the view
>alter authorization on database ::DB_Name to xxxxxx ---to grant the view on particular DB
But here by default the database roll "db_owner" role,
i tried to change the db role from owner to Reader but it is showing an error like "Cannot use the special Pricipal dbo".
If want to change it to "db_datareader" role what can i do...