Add a new user to a database

Hi all,
Is there an example to show how to add a new user to a database giving access to different tables ,views.
Thanks,
Jeff