July 22, 2003 at 7:53 am
I've recently created a SQL Server 2000 database which allows changes to some of the tables but not others. The public role is set to allow changes to all the tables. Any assistance would be appreciated.
July 22, 2003 at 8:11 am
Public Role does not have update permission to all tables by default unless you grant it the permission. Create a new Role with proper permissions to select/update your particular tables and add your users as member of this new role.
July 22, 2003 at 8:50 am
Hi scking,
quote:
I've recently created a SQL Server 2000 database which allows changes to some of the tables but not others. The public role is set to allow changes to all the tables. Any assistance would be appreciated.
just out of curiosity, what are you doing this for?
Are temporary tables an alternative?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
July 23, 2003 at 3:54 pm
The public role was set up to have update permissions but I still did not work. This problem seems to have corrected itself because I can not make the changes that were impossible yesterday. It's probably something I changed with permissions but I am not sure what.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply