Re: permissions gone missing in sysprotects

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 01/28/05 

Date: Thu, 27 Jan 2005 18:59:23 -0700

I have never heard of this one.
One way I could see having problems is if you had modified
system tables. That's the only scenario I can think of but I
would have thought you'd get an error in the upgrade
process.
As already suggested in one of the other groups, you should
contact Microsoft Product Support if you feel you have a
bug.

-Sue

On Wed, 26 Jan 2005 20:45:02 -0800, "Jack Yao"
<JackYao@discussions.microsoft.com> wrote:

>Hi there,
>
>I have found the bugs when upgarded DB from sql 7.0 to sql 2000 and I
>noticed that load of records have gone missing in sysprotects table (
>something like from 5000 records down to 60 records only).
>
>As a results, permission setting does not appear in objects permission
>management in Enterprise Manager.
>
>I know that the permission setting is still hold in syspermissions table,
>but without the "green ticks" appears on the Enterprise manager interface, we
>would not be able to know what permission we have assigned to each role or
>user at all.
>
>This problem only happen with the database that has been moved from 7.0 to
>2000 though , if you move db from 2000 to 2000, it seems to be fine.
>
>Does anyone else out there know how to fix this ?
>
>cheers
>
>Jack

Relevant Pages

  • permissions gone missing in sysprotects
    ... I have upgarded db from sql 7.0 to sql 2000 and I notice that load of ... records have gone missing in sysprotects table (something like from 5000 ... I know that the permission setting is still hold in syspermissions table, ... but without the "green ticks" appears on the Enterprise manager interface, ...
    (microsoft.public.sqlserver.server)
  • permissions gone missing in sysprotects
    ... I have upgarded db from sql 7.0 to sql 2000 and I notice that load of ... records have gone missing in sysprotects table (something like from 5000 ... I know that the permission setting is still hold in syspermissions table, ... but without the "green ticks" appears on the Enterprise manager interface, ...
    (microsoft.public.sqlserver.server)
  • permissions gone missing in sysprotects
    ... I have upgarded db from sql 7.0 to sql 2000 and I notice that load of ... records have gone missing in sysprotects table (something like from 5000 ... I know that the permission setting is still hold in syspermissions table, ... but without the "green ticks" appears on the Enterprise manager interface, ...
    (microsoft.public.sqlserver.setup)
  • record gone missing in sysprotects
    ... I have upgarded db from sql 7.0 to sql 2000 and I notice that load of ... records have gone missing in sysprotects table (something like from 5000 ... I know that the permission setting is still hold in syspermissions table, ... but without the "green ticks" appears on the Enterprise manager interface, ...
    (microsoft.public.sqlserver.security)
  • permissions gone missing in sysprotects
    ... I have found the bugs when upgarded DB from sql 7.0 to sql 2000 and I ... noticed that load of records have gone missing in sysprotects table ( ... I know that the permission setting is still hold in syspermissions table, ... but without the "green ticks" appears on the Enterprise manager interface, ...
    (microsoft.public.sqlserver.security)