I need some help assigning a special user some special privileges (Role).
I need to give the user reading rights on all tables.
I need to give the user creating right if views.
I don't want to allow him ddl_admin since then he will be able to Drop & Truncate tables.
I think I need to create flexible database role but I don't know how to.
Thanks in advance,