Search This Blog

Saturday, 8 March 2014

Msg 10332:SELECT permission denied on column audflags of object sysobjects, database

error:

Msg 10332, Level 14, State 1:
Server '%s%', Line 1:
SELECT permission denied on column audflags of object sysobjects, database dxpo, owner dbo

Simple resolution:

grant all on sysobjects to public

go

error
Msg 10331, Level 14, State 1:
Server '%s%', Line 1:
CREATE TABLE permission denied, database %s%, owner dbo


No comments:

Post a Comment