Hi,
With Yukon the permissions which are applicable to a securable can also
be applied at parent level. In case of database the permissions are
applicable to all schemas, all objects in that schemas. On the database
permissions tab there are two permissions 'Alter' & 'Alter any schema'. I
guess this is to allow just the 'alter' on schema but not ont all other
types e.g. assemblies. But then why not 'control any schema'
Re: Security to document databases ... The default public permissions should provide the needed permissions in SQL ... 2000 to view schema.... there are many third party tools that can help automate database... their ability to get a list of database objects in enterprise manager. ... (microsoft.public.sqlserver.security)
Re: Cross-database execution permissions with certificates and sch ... around the service broker activated user.... I agree that this is a good use of schema as a security boundary. ... The comment about schema scoped permissions not being applicable in my ... the certificate is a trusted authenticator because you granted AUTHENTICATE ... (microsoft.public.sqlserver.security)
Re: SQL Adapter -Stored Procedure Permissions- issue, -SQL 2005- ...Permissions were granted on the table, ... 'Security Users' of the database, then we add that user to a 'Roles ...SQL Adapter schema generation wizard and when the schema is created ... (microsoft.public.biztalk.general)
Re: Trouble Extending Schema ... I can't get the schema extended but I beleive I ... have the permissions set correctly.... >> I'm trying to find out why it won't let me extend the directory. ... >> correct permission when creating the SMS System Management container.... (microsoft.public.sms.setup)
Re: Need help on how to organize users and objects ... create and execute procedures and such ... tables they need and I grant them select permissions to them. ... so I think that the best way will be to create Schema to Role and then you ... and then create an appropriate permissons for those roles in database... (microsoft.public.sqlserver.security)
