Set User Options For Current Database. SELECT - Allow a user to select data from a database. Step 2 - Once the databases list is ready loop through these database to create a user for that login and grant it read and write access on each database.
To reverse this change false to true. If you want to give them access to any database or to any table make sure to put an asterisk in the place of the database name or table name. In the Database tool window View Tool Windows Database click the Data Source Properties icon.
When its in Full log files continue to grow until backed up.
In the Database tool window View Tool Windows Database click the Data Source Properties icon. It will give you the name the database you are running using while running the query. From the Standard bar click New Query. CREATE - Allow a user to create databases and tables.