Looks like it would be great if someone who knows Access can step in. But if all users look the same to SQL Server, there is not much you can...

sqlfriends (1/22/2014)And by replacing sp_adduser with create user, there is no schema created for the user for all the databases except one - master, why in master database the ...

sqlfriends (1/21/2014)

---

By reading from the definition from microsoft site below, it look like we grant view definition on server level, also add the user to the database without granting any...

The user still has VIEW DEFINITION in the database, as it was granted VIEW ANY DEFINITION on server level.

That is, the user can see the definition of all tables, stored...

As George says, the script adds the user to model and master as well. And it will probably will produce an error when it attempts to add the user to...

Obviously, if all users look the same in SQL Server, there is not much you can do.

Then again, why would you not be able to set up the linked tables...

Nah, the point with FileTable is exactly that it makes it possible to update the database from Explorer and similar. The difference between storing just a file path in the...

What I did not mention, but which you should be aware of is that a solution where the application sends the password to the database is open for a man-in-the-middle...

You raise some valid questions there. Indeed, if it is possible to retrieve the encrypted data by running a stored procedure, you only have security by obscurity.

I can see three...

To clarify what Keith is saying: to install security updates, you don't need any permissions in SQL Server at all, only in Windows.

The syntax for CREATE SERVER AUDIT is:

[sql]

CREATE SERVER AUDIT audit_name

{

TO { [ FILE (<file_options> [ , ...n ] ) ] | APPLICATION_LOG | SECURITY_LOG }

...

This is obviously a security issue, since this permits a user to replace an existing package that is scheduled to run with his own package which may do all sorts...

I've made some research and the query does indeed come from Activity Monitor. Furthermore, the query is the same in SQL 2012 SP1. And for that matter, SQL 2014 CTP2.

I...

From what you have told me, you are loading data from a Progress table every day. I assume that you don't make it just...

Here is the problem. Sysprocess does not have one per process, it has one per process and execution context...