meta user
network profile
| bio | website | |
|---|---|---|
| location | Munich | |
| age | ||
| visits | member for | 2 years |
| seen | 2 hours ago | |
| stats | profile views | 733 |
I'm looking for job as a software developer (Java) with focus on relational database technologies (Oracle, PostgreSQL)
|
May 13 |
comment |
If the users need INSERT/UPDATE/DELETE permissions, is Windows auth still more secure than SQL Server auth? I fail to see how the stored procedure would prevent anything. If the user connecting to the database can call the stored procedures through the MS Access, then he/she can very well call them "manually" as well (and I don't see why this would be related to Windows Auth - if you had a SQL Server user for each and everyone, you'd have exactly the same situation). If a user shouldn't be allowed to delete data, then revoke the DELETE privilege. |
|
May 13 |
revised |
Error in trigger: table is mutating improved formatting |
|
May 13 |
answered | Error in trigger: table is mutating |
|
May 13 |
revised |
Error in trigger: table is mutating edited tags |
|
May 13 |
revised |
What happen when Postgresql tablespace is null? Improved formatting |
|
May 13 |
comment |
Remove collation from all database columns One thing to note: you cannot change the collation of a column that is part of an index or constraint. You will need to drop the index/constraint before being able to change the collation - which requires a bit more scripting. |
|
May 12 |
awarded | Custodian |
|
May 12 |
reviewed | Leave Open Queries getting stuck on very simple COUNT queries |
|
May 12 |
reviewed | Leave Open Data dictionary best practices in SQL Server 2008 r2 |
|
May 12 |
reviewed | No Action Needed Simple model database transaction log full 'CHECKPOINT' |
|
May 12 |
reviewed | Approve suggested edit on Installing and enabling both master and slave semisynchronous plugins on same server |
|
May 12 |
revised |
create database table with a owner in my SQL edited tags |
|
May 11 |
revised |
Missing quotation - openquery to oracle edited tags |
|
May 11 |
comment |
How to “swap” out production tables "a few thousand" rows is nothing. Just do the insert/delete in a single transaction and everything should be fine. If inserting a few thousand rows is slow your problem is somewhere else. That shouldn't take longer than a couple of seconds. |
|
May 10 |
comment |
Seeting up a PostgreSQL database on another hard drive than my system one on OS X? You don't really need the symbolic link. Just tell pg_ctl where the data directory is located using the -D switch. Don't know how Postgres is started on OSX, so I can't tell where this is configured. |
|
May 10 |
comment |
createdb: could not connect to database postgres: FATAL: could not write init file 8.2.3 is extremely old and unsupported. You should plan an upgrade to 9.x as soon as possible. |
|
May 10 |
revised |
Sort by selected deleted 4 characters in body |
|
May 10 |
comment |
Sort by selected I think this is probably better suited on superuser |
|
May 10 |
answered | Built-in XML functions |
|
May 10 |
revised |
Encryption in PostgreSQL added 1 characters in body |
