Re: sql 7.0 to sql 2000 upgrade user/permissions

From: Richard J. Fowler (richardjfowler@msn.com)
Date: 05/08/02 

From: "Richard J. Fowler" <richardjfowler@msn.com>
Date: Wed, 8 May 2002 08:26:35 -0600

Thanks for the feedback.

I'm familiar with the sp_change_users_login and the sid problems. Since no
users are being restored to the database, it is not the issue. Permissions
have been assigned to the public role but not to any users.

It seems as if it has to do with the permissions to grant permissions. The
dbo user did gets restored as an NT user (this did have the sid problem) but
I changed that to sa. The sysprotects table does not contain the rows
applying permissions for the public role.

Is it possible that the sp_changedbowner did not complete its task because
of the sid conflicts? I've checked everything that the sp_sidmap sp checks
(Q240872) and the readme for sp_sidmap implies that sp_changedbowner should
work.

Any other suggestions?

Thanks - Rich F.

"Dan Guzman" <danguzman@nospam-earthlink.net> wrote in message
news:#is02Op9BHA.2244@tkmsftngp03...
> It may be that the syslogins/sysuser mapping is out of sync due to the
> restore. You might check out sp_change_users_login in the Books Online
> to remedy the situation.
>
>
> Hope this helps.
>
>
> Dan Guzman
> SQL Server MVP
>
> -----------------------
> SQL FAQ links (courtesy Neil Pike):
>
> http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
> http://www.sqlserverfaq.com
> http://www.mssqlserver.com/faq
> -----------------------
>
> "Richard J. Fowler" <richardjfowler@msn.com> wrote in message
> news:e7o#ebi9BHA.2540@tkmsftngp05...
> > I'm using a database restore to upgrade a sql 7.0 database to a sql
> 2000
> > database. The public user has full permissions. I'm logged on as sa to
> do
> > the restore from enterprise manager. After the upgrade, I am not able
> to
> > change the permission using either t-sql or enterprise manager. The
> commands
> > seem to complete successfully but the changes do not get made. If I
> add a
> > user (Windows Group), I am not able to set the permissions for the
> user.
> > sysprotects does not get updated. I've tried changing the database
> owner to
> > sa but that does not help I cannot get the database to accept any
> permission
> > setting except for database permissions.
> >
> > Thanks - Rich F.
> >
> >
>
>

Relevant Pages

  • Re: Making changes to existing WSS intranet
    ... I thought then that perhaps I should have created a new virtual server, ... > recreate the old site and then restore that backup to that site. ... > can check to the option to create a new content database instead of using ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: List Users Permissions down to table.column action
    ... THIS STORED PROCEDURE GENERATES COMMANDS ... -- FIXED PROBLEMS WITH STATEMENT LEVEL PERMISSIONS GRANTING. ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- GRANT USER ACCESS TO SERVER ROLES ...
    (microsoft.public.sqlserver.security)
  • Re: User access on a company intranet
    ... Yes they need full permissions on the folder where the backend is. ... You wouldn't need to do this in your copy of the database. ... However you can toggle the shiftkey bypass from another mdb file. ... When you want to implement security, you create a new mdw file, ...
    (microsoft.public.access.security)
  • Re: Active directory corruption
    ... During an installation of PHP I accidentally changed permissions for the ... Active Directory database is unavailable because it is damaged, ... Open a command prompt and run NTDSUTIL to verify the paths for the ...
    (microsoft.public.windows.server.sbs)
  • Re: Active directory corruption
    ... default web site and copied the permissions to all the child ... as it may not be the database that is the problem. ... prompt, use the ESENTUTL to check the integrity of the database. ... To recover the database type the following at the command prompt: ...
    (microsoft.public.windows.server.sbs)