[Enhancement]: Improve User Security Documentation

[jgngo]

Describe how this change will improve the Babelfish website.

This will help new users to understand the current limitations of Babelfish regarding user permissions.

Share implementation details for the website enhancement.

When you create a new user using CREATE LOGIN newuser WITH PASSWORD = 'newpassword' in T-SQL, this will create a user with babelfish roles master_guest and tempdb_guest. This allows the user to only access master and tempdb databases as guest. If you want to give this user read and write permissions to other databases in babelfish, you will need to login to a PostgreSQL client and run grant sysadmin to newuser which will provide full access to all databases created in Babelfish. Unfortunately this is an all or nothing permission system for now and work is in progress on building out database principal and permissions in Babelfish.

Relevant documentation

https://github.com/babelfish-for-postgresql/babelfish_extensions/issues/67

Code of Conduct

• I agree to follow this project's Code of Conduct.

[robverschoor]

In v.1.2.0 or later, the database owner can give the login access to this database by running CREATE USER in the database for that login.