Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2003
    Location
    India
    Posts
    4

    Unanswered: SQL Server 7 to 2000 Migration Problem

    I have successfully migrated a SQL Server 7 Database Server to SQL Server 2000 Server. All the databases were migrated properly.

    A strange thing happens when I create a table in one of those migrated database and assign SELECT permission to PUBLIC. The SELECT permission disappears from the table. I am not able to assign it to the PUBLIC.

    Any clue? help?

    Thanks in advance.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Tried with GRANT statement?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Jun 2003
    Location
    India
    Posts
    4
    Yes, I have tried all options inclding Enterprise Manager's graphical screen's tick mark.

    The tick mark just vaishes after a refresh.

  4. #4
    Join Date
    Jun 2003
    Location
    India
    Posts
    4
    Sorry for the typo, I meant to say

    The tick mark just vanishes after a refresh.

  5. #5
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Run SP_HELPGROUP and SP_HELPROLE for the results.

    Do you have any issue for PUBLIC group with this activity.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  6. #6
    Join Date
    Jun 2003
    Location
    India
    Posts
    4
    The problem is if I give GRANT permission to any USER on any TABLE, the permissioning takes place, but SQL Server does not put any entry in the SYSPROTECTS table. That means the USER gets the permission to access the TABLE, but you don't see the permission entry in the SYSPROTECTS table. So, in the ENTERPRISE MANAGER also you don't see a tick mark.

    In short, I am able to give permission to the user but I don't really get to see who got permission to access what.

  7. #7
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Any information from SQL error log?
    Any changes you made to the SQL system from 7 to 2000 while upgrading?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •