under login properties no server role is defined, and under database
access the 3 databases i need the user to access is checked. When i
click on the database it shows public, and db_denydatawriter is
checked. I dont know where else top check.
Re: securityadmin ... add the database user to db_datareader, ...fixed server role Security Administrators.... I can go ahead and add that login as a database user and add them ... (microsoft.public.sqlserver.security)
Re: User permissions. ... > System Admins Server Role?... You are correct that DENY has no effect on sysadmin role members because ... Also note that the db_owner fixed database role is very a powerful one. ... (microsoft.public.sqlserver.security)
Re: Setup login account for application developer to access sql server ... You wouldn't want sa - members of sysadmin can perform any ... any activity in any database.... >Is it i need to give sa server role and then db owner db roles to the db to ... >or i just need to give db owner db roles to the user but no need to give any ... (microsoft.public.sqlserver.security)
Re: server roles for backup ... No the "diskadmin" server role does not give logins access to perform ... operators access to perform backups you can give them access to the ... > tapeadmin user the database server role of disk administrators give the ... (microsoft.public.sqlserver.server)
Re: Error executing Backup ... For RESTORE you cannot use db_backup operator if the database doesn't exist, ...dbcreator server role should do. ... I've configure "HP Omniback" to perform backups on ... configured this account i assign this account the "System ... (microsoft.public.sqlserver.server)
