Sure, when you create the user in a database do not grant any default role. Then run grant select on yourview to theuser
Forum Rules