Q113158

• Microsoft SQL Server version 4.2x

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 

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