New answers tagged

1

I believe I found the real issue. SharePoint 2010 is NOT compatible with SQL 2014. SQL Server 2014 and SharePoint supportability


1

This is an operating system error, reported to the SQL Server service. The SQL Server service account, which creates the files, needs to have at least change permissions on the d:\data folder and it needs to exist.


0

SQL Server column level encryption consists of five types of keys. They are Service Master Key, Database Master Key, Asymmetric key, Certificate and Symmetric key. Whenever you implement column level encryption, a complete hierarchy of keys needs to be created and able to decrypt the other keys along the hierarchy. All keys are encrypted in the system at all ...


0

Postgresql implements Host-Based Access control using pg_hba.conf file. This file is located in the data directory of database cluster. The format of this file is All parameters in a single line (Here they are numbered for convenience) To prevent outside connection to your server, 1. local|remote(host|hostssl|hostnossl) connection: local 2. Database ...


0

I have never seen that personally, so I looked up all the functions in Postgres found in the docs here. The only thing it showed remotely close was 'network address functions' in this section. Outside of that the docs don't show anything for network access functions. Note this doesn't mean you can't write your own functions that access the system or OS ...


1

Create a function like the one below; CREATE OR REPLACE FUNCTION public.explain_this ( l_query text, out explain text ) RETURNS SETOF text AS $body$ BEGIN RETURN QUERY EXECUTE 'explain ' || l_query; END; $body$ LANGUAGE 'plpgsql' VOLATILE RETURNS NULL ON NULL INPUT SECURITY DEFINER COST 100 ...


0

This is MySQL's random number generator: double my_rnd(struct rand_struct *rand_st) { rand_st->seed1= (rand_st->seed1*3+rand_st->seed2) % rand_st->max_value; rand_st->seed2= (rand_st->seed1+rand_st->seed2+33) % rand_st->max_value; return (((double) rand_st->seed1) / rand_st->max_value_dbl); } You will need to pass ...


1

I do not believe that this is truly possible, at least not in any truly accurate and meaningful way. The problem is, even taking into account the level of complexity that you have already identified (emphasis added): information about User-Permissions on object-level directly as well as through DB-Roles and also recursive DB-Role-in-DB-Role permissions ...


0

Once someone executes INSERT DELAYED, a system thread will open in order to track and mitigate INSERTs of this kind. MySQL 5.6 deprecates it and 5.7 does not support it. What is more, in terms of MySQL Replication, Slaves will completely ignore an INSERT DELAYED command from a Master and execute them as a standard INSERT. Please read the MySQL 5.5 ...


5

No, I am not aware of any built-in function that does exactly this. But, you can still accomplish this without doing anything too complicated. You could use the built-in CRYPT_GEN_RANDOM function (introduced in SQL Server 2008 R2) which generates random values based on a supplied length. The output is in hex/binary values so each byte returned is ...


2

How to migrate windows login in from one sql server to another sql server on another domain So whatever logins the database has in DMN1 cannot be used in DMN2 anymore. it would take a lot of time to sort out a lot of windows logins in DMN1, get their equivalent login in DMN2 and map them to the right databases. What would be an easier way of doing ...


0

It seems like a limiting factor here might be that we don't want to make a connection string for each client and separate the user used to connect to the DB back end that way. As a result we are using a SQL Database user that has full access to all the databases, with them really only needing access to 1 DB that being their own. In the current security ...


1

You'd need to have select access on the specific table granted to you with the admin option GRANT SELECT ON <<table name>> TO dwhManager WITH ADMIN OPTION; That would need to be run for each table. You could do that in a loop with dynamic SQL BEGIN FOR t IN (SELECT * FROM dba_tables WHERE owner = <<...


1

You probably want GRANT ANY OBJECT PRIVILEGE AS DBA: GRANT GRANT ANY OBJECT PRIVILEGE TO dwhmanager; AS dwhmanager: grant select on DWHFINANCE.SALES TO johndeveloper; Presto!


0

This sounds like a case where the key_guid in the encrypted data does not match the key_guid for the symmetric key used to encrypt it. When data encrypted using a symmetric key and is then saved in a varbinary column, the first 16 bytes are the Key_guid of the symmetric key used to encrypt the data, which explains how DECRYPTBYKEYAUTOCERT can automatically ...


1

You might be asking too broad of a question but if you wanted to have a user only have access to a table in SQL Server you could simply do a: --Create Server Level User USE [master] GO CREATE LOGIN [(UserName)] WITH PASSWORD=N'PutPasswordHere' DEFAULT_DATABASE=[DatabaseName] GO --Create DB Level Uesr use [DatabaseName] GO CREATE USER (username) FOR LOGIN (...



Top 50 recent answers are included