I create new tables from time to timeand was wondering if there was a way to make the Pulic role the default.
Now I give the user a program only to find out there is an ODBC error "they don't have permissions"
So I come back to the SQL server and open Enterprise manager and set that table to be Public.
The 4 permissions that is (put a check in the box)
Select, Insert, Update, Delete
So when I create a new table I would like the 4 Public permissions above to be set as the table is created.
TIA
DougP, MCP
Visit my WEB site to see how Bar-codes can help you be more productive
Now I give the user a program only to find out there is an ODBC error "they don't have permissions"
So I come back to the SQL server and open Enterprise manager and set that table to be Public.
The 4 permissions that is (put a check in the box)
Select, Insert, Update, Delete
So when I create a new table I would like the 4 Public permissions above to be set as the table is created.
TIA
DougP, MCP
Visit my WEB site to see how Bar-codes can help you be more productive