If you need to delete one user and add the entire related table that user to another user you can easily use this method.
--=========== --example 1 --=========== use master go --to set system table update configure sp_configure 'allow updates', 1 GO RECONFIGURE WITH OVERRIDE GO --=========== --example 2 --=========== use master go --to get user id DECLARE @intNewUid int DECLARE @intOldUid int SELECT @intNewUid=uid FROM pubs.dbo.sysusers WHERE (name='Tharindu');--new user SELECT @intOldUid=uid FROM pubs.dbo.sysusers WHERE (name='dbo');--old user --Update values UPDATE pubs.dbo.sysobjects SET uid=@intNewUid WHERE (type='U') and (uid=@intOldUid); go
This article covers four of the fixed database roles (db_datareader, db_datawriter, db_denydatareader, and db_denydatawriter). If you're new to SQL security (and maybe even if you're not) this article is worth reading.
2003-10-10
10,262 reads
Learn how to secure your data by implementing SQL Server security best practices.
2001-09-20
3,675 reads
2001-07-19
2,549 reads
2001-06-14
5,586 reads
2001-05-25
3,983 reads
