Disable user configurable Subscription

Hi,

Does anyone know if you can disable a users ability to set their own schedules and only choose from shared schedules for their reports. The reason I ask is because we have a window from about 3-7 in the morning where we do DTS and maintenance etc and dont want the databases queried as the results could be wrong. Therefore we want to setup a range of shared schedules for users to pick which wont coincide with that time.

Thanks in advance

Dan.

Sorry this feature does not exist in the current subscription framework. You could write your own delivery extension that did this, but it would not stop someone from using another extension and using a non shared schedule.

Disable database diagram creation

I have a MSSQL 2000 SP4 server.
I need to disable ability to create database diagrams for users.
How can I do this?To create a diagram, they would need to be the database
owner or a member of the db_owner role (or a sysadmin).
Don't add them to those roles.
You can figure out the specific object permissions in the
following article - different issue than yours but it lists
the permissions.
http://support.microsoft.com/?id=327145
-Sue
On 24 Oct 2006 08:38:06 -0700, slousch@.gmail.com wrote:

>I have a MSSQL 2000 SP4 server.
>I need to disable ability to create database diagrams for users.
>How can I do this?|||User is not db_owner and not in sysadmin,
there are no permissions to public database role,
but he is still able to create diagrams.
I want to get "You do not have sufficient privileges to create the new
diagram." message,
when user trying to creaate diagram.
Sue Hoegemeier wrote:
> To create a diagram, they would need to be the database
> owner or a member of the db_owner role (or a sysadmin).
> Don't add them to those roles.
> You can figure out the specific object permissions in the
> following article - different issue than yours but it lists
> the permissions.
> http://support.microsoft.com/?id=327145
> -Sue|||Check the permissions on the objects listed in the article.
-Sue
On 25 Oct 2006 04:09:54 -0700, slousch@.gmail.com wrote:
[vbcol=seagreen]
>User is not db_owner and not in sysadmin,
>there are no permissions to public database role,
>but he is still able to create diagrams.
>I want to get "You do not have sufficient privileges to create the new
>diagram." message,
>when user trying to creaate diagram.
>Sue Hoegemeier wrote: