"public" role in SQL 2005 Not available
Posted: Sun Aug 02, 2009 7:00 pm
In following the 7.0 setup on Installation Readme it says:
Where can I find a way to associate that role to the user SA that I created?
Using EMS SQL Manager 2008 for SQL server I was able to do step 3 but it did not list "public" as a role.Create a Database
These steps are not required if you have installed and are using the included SQL 2005 Express database file.
1. Create a new blank database. (only for Microsoft SQL Server 2000 or 2005)
2. Create a new user login, or use an existing login (username and password) and give this user access to the database.
3. Make sure the Permitted Roles are "public", "db_accessadmin", "db_securityadmin", "db_dlladmin", "db_datareader", "db_datawriter"
Where can I find a way to associate that role to the user SA that I created?