Tagged Questions
0
votes
1answer
66 views
How to deny access to see the logins in a database
I create a login in SQL Server 2008 R2, and when that user connects to a database, it can see all the logins in the security logins. Can I deny access to watch the logins of the database?
2
votes
1answer
201 views
How to grant permission for am administrator account in SQL Server 2012? [closed]
I installed SQL Server 2012 on my laptop. I am trying to run a script to create a simple database.
SQL Server version: 11.0.3128
SSMS starting parameters:
server type: database engine
server name: ...
9
votes
1answer
349 views
Are there reasons why I should not set my db owner to [sa]?
Yesterday I asked this question regarding changing the dbo of multiple databases that I have. The change makes sense, but I want to be clear.
Is there any, good reason or circumstance why I should ...
2
votes
1answer
177 views
Active Directory domain being shutdown— Do I have to update my DBO accounts?
I manage a SQL Server machine (with SQL Server 2000 and 2005 installed) that was first created on an Active Directory domain that we are transitioning away from and are about to shut down. All of my ...
1
vote
1answer
201 views
MySQL Grant Permission
I want to Grant a user only INSERT permission.
When I try to insert data, it throws the error "Access Denied".
What permission do I give a user to use/select database in mysql and how?
I have given ...
