[MS SQL Server] permission for build account |
- permission for build account
- Is it possible to remove "public" role for database user ?
- connect to SQL 2005 Databse through application
- How notificate create database event
| Posted: 17 May 2013 03:50 AM PDT I have security question.We have an account used for database build, it needs to restore a database from a prodcution backup and then create and alter some objects in the database.I granted it db creator permssion,but after it creates the databse, it needs to run the alter statement, it failed because it doesn't have permission. By reading some articles online, I got to know that even it is a dbcreator, it doesn't have permisson in the database objects, this sounds strange to me, I thought if it creates db it should be automatically becomes the dbowner, but apparently not. one note is in the production database, it doesn't have the build account as a login.Thanks, |
| Is it possible to remove "public" role for database user ? Posted: 16 May 2013 10:13 PM PDT Guys,SQL Server 2008 R2 with SP1Is it possible to remove "public" role for database user ?I am not able to uncheck it.. Please guide.Thanks in advance,Smith |
| connect to SQL 2005 Databse through application Posted: 16 May 2013 07:58 PM PDT we have .net application. we have to connect to Database through this application.i have tried below...1) SQL Login with SysAdmin role (its working, but it is not accepted as security reasons)2) SQL Login with dbo_owner role (it is opened application, but when click on buttons in the application which is giving error)3) Created application role and assinged dbo_owner. (it is not opening application)Note: we are giving user name and password in connection string of application.So, what is the better way and which type of user need to create to connect this database only through the application ? |
| How notificate create database event Posted: 02 Mar 2011 12:32 AM PST Hi,I need to detect when a new database is created in my SQL Server and send a mail notification to all dba-s.My idea is to do that with notification services: first i capture the create database event, second i enquee message in the queue and finally i process this queue sending notification mails to all dba-s.Someone could tell me if it is possible? How I can read the messages from a queue to send notifications by mail? How i can see the queue content?Many thanks in advance. |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment