Re: permissions gone missing in sysprotects
From: Derek (anonymous_at_devdex.com)
Date: 02/13/05
- Previous message: Dan Guzman: "Re: Execute Persmission denied on object 'sp_OACreate'"
- In reply to: Jack Yao: "Re: permissions gone missing in sysprotects"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Sun, 13 Feb 2005 09:39:59 -0800
Hi Jack, if you have the SQL 7,0 instance still available, once you have
the objects and data in from the current production SQL 2000 instance,
you could script the permissions from the SQL 7.0 instance using the
‘Generate Scripts’ option in Enterprise Manager. If you choose the
option to ‘script all objects’ on the General Tab, then remove the
‘Create’ and ‘Drop’ options from the Formatting Tab and then select
‘Script object level permissions’ from the Options Tab, you should just
end up with just the permissions scripts. If you run that script against
the new SQL 2000 database, it should populate all the systems tables
correctly. I would first remove any bad permissions from the
syspermissions table incase they get scripted.
Use this script to identify the bad permissions.
select b.name, b.type, a.* from syspermissions a, sysobjects b where
a.id = b.id
and b.type not in ('u', 's', 'p', 'v')
order by b.type
Cheers
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
- Previous message: Dan Guzman: "Re: Execute Persmission denied on object 'sp_OACreate'"
- In reply to: Jack Yao: "Re: permissions gone missing in sysprotects"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
