RE: mirroring admin permissions

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

When viewing the list of permissions under "Database Properties \
Permissions", there is "ALTER". The user already has this permission. Can we
assume that granting this permission extends to "ALTER DATABASE"? There are a
number of "ALTER ANY" permissions (e.g. ALTER ANY ROLE, ALTER ANY SCHEMA,
etc.). Should one of these be granted too?

The properties of the mirror database cannot be accessed while it is a
mirror. Is it correct to assume that the permission settings made to the
Principal will propagate to the Mirror?
.

Relevant Pages

  • Re: DDL Permissions - CREATE PROCEDURE, but no CREATE TABLE
    ... Sorry, you are correct, I misread the original message. ... if you want this person to use the dbo user. ... > reponse is angled towards data access permissions. ... > to CREATE, ALTER, or DROP tables or other objects. ...
    (microsoft.public.sqlserver.security)
  • Re: permissions resetting on a View
    ... you run the sp_refreshview it appears to keep the permissions on a view. ... If you really want to create or alter a view via a stored procedure you can ... "Terrell Miller" wrote in message ... > delete the view and recreate it? ...
    (microsoft.public.sqlserver.server)
  • Re: How to determine if a user has a permission programmatically?
    ... I need to determine in advance if a user logged on to SQL Server 2005 can ... sp_addrolemember and ALTER LOGIN). ... determine programmatically if a user has specific permissions (ALTER ANY ...
    (microsoft.public.sqlserver.security)
  • Re: The "Best Practice" for securing my vb.net/SQL connection.
    ... Users will not be able to bypass the security built into the end client by using the SP to run select and update statements at will, because they cannot alter the stored procedures. ... If you only give users Execute permissions on stored procedures and no other permissions, I don't really see what they can do to break things. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: "Your system has no paging file"
    ... > Your system has no paging file, or the paging file is too small. ... But, to help, did you alter the permissions on the C: ... Microsoft Windows MVP - Windows Server - Directory Services ...
    (microsoft.public.win2000.dns)