Microsoft KB Archive/113158

BUG: Schema Generate Does Not Include Statement Permissions

Q113158

The information in this article applies to:

Microsoft SQL Server version 4.2x

BUG# 9892 (4.2)

SYMPTOMS

Object Manager's schema generate function does not put statement permissions granted to users or groups into the generated script.

If a database has users or groups which have been granted statement permissions, schema generate will not include the grants in its generated scripts. For example, if a site does

   use pubs
   go
   sp_addlogin testlgin, NULL, pubs, NULL
   go
   sp_addgroup testgrp
   go
   sp_adduser testlgin, testuser, testgrp
   go
   grant create database, create default, create procedure,
         create rule, create table, create view,
         dump database, dump transaction
   to testuser
   go
   grant create database, create default, create procedure,
         create rule, create table, create view,
         dump database, dump transaction
   to testgrp
   go

Then if the site uses schema generator to generate a script with all objects, users and logins, the statement permission grants will not be included in the generated script.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 4.2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: Windows NT

Keywords : kbother kbtool
Issue type :
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ420OS2