Microsoft KB Archive/113158

{|
 * width="100%"|

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