All Questions
Tagged with users sql-server-2014
8 questions
2
votes
1
answer
2k
views
Adding AD Security group to a SQL linked server
I have a question about adding permissions for a user group on a linked server in SQL Server. I am not a security specialist, so I appeal to everyone.
Here is the topo:
I have private software that I'...
- 55
0
votes
3
answers
500
views
Allow user to create databases on server and to see only the databases that are created by him, without creating login first
I want to implement the following use case using C# application and MS SQL Server Express 2014. I have a centralized database server in which there are already created some database (which have the ...
- 71
1
vote
1
answer
1k
views
Assign Permissions to a SQL User
I have active directory on my company, I have some login users created at the level of the SQL Server (2014) that I need to propagate to all my databases on that server. I want to create a read only ...
- 45
3
votes
1
answer
4k
views
Minimum credentials on SQL Server to connect via Power BI Desktop
Note: This is not a Power BI issue, this is a DB credential issue.
In Power BI Desktop, I am trying to connect to a database, but I only want that user to have SELECT access.
I have one User that is ...
- 133
2
votes
1
answer
881
views
User created automatically because of AD Group?
I have a Development SQL Server that I'm managing with Active Directory Groups, sometimes when I do my checks on the server I find that some users were "automatically" added to SQL Server Database ...
- 530
2
votes
2
answers
4k
views
Should I disable the guest user on system databases
The guest user is disabled on our user databases but data security guys want us to disable it on system databases as well. Should I do it?
- 21
12
votes
1
answer
45k
views
How to change the login for a database's dbo user?
I just finished a successful install of SQL Server 2014 Express, onto a domain-joined VM instance of Win8.1.
During setup which I ran under DOMAIN\Admin I accepted the default configuration of adding ...
- 559
3
votes
1
answer
8k
views
DROP LOGIN fails on SQL Server 2014
We have a database with an owner 'dbowner'. Our install procedure drops the login for user 'dbowner' and creates it again.
On any other version of SQL Server the following SQL query succeeds:
USE [...
- 31