Viewing 15 posts - 1,156 through 1,170 (of 3,738 total)
John Mitchell-245523 (10/11/2012)
Welsh Corgi (10/11/2012)
Could you please expand on your comments about DELETE and the ON Clause?
Yes - try DENYing DELETE or ALTER on the schema that the tables are...
October 12, 2012 at 9:31 pm
John Mitchell-245523 (10/12/2012)
Has the user in question tried dropping any objects since you denied ALTER on the schema?John
Not yet, thanks.
October 12, 2012 at 9:52 am
John Mitchell-245523 (10/12/2012)
So you've tried DENY DELETE instead of DENY DROP?john
I do not want to restrict the users from Deleting Data, I just want to restrict them from Dropping Tables.
October 12, 2012 at 8:49 am
John Mitchell-245523 (10/12/2012)
Not DENY ALTER SCHEMA. Something like DENY ALTER ON SCHEMA::SchemaName. You'd have to check out the exact syntax yourself if that isn't quite correct.John
DENY ALTER ON...
October 12, 2012 at 8:20 am
John Mitchell-245523 (10/11/2012)
Welsh Corgi (10/11/2012)
Could you please expand on your comments about DELETE and the ON Clause?
Yes - try DENYing DELETE or ALTER on the schema that the tables are...
October 11, 2012 at 9:51 am
Ratheesh.K.Nair (10/11/2012)
Welsh Corgi (10/11/2012)
Ratheesh.K.Nair (10/11/2012)
If you want to DENY Create,Drop & Alter why cant you give a less privilege to that user??
I had then as DDL Admin but there is...
October 11, 2012 at 9:21 am
John Mitchell-245523 (10/11/2012)
(1) Use DELETE instead of DROP
(2) Add an ON clause (although I don't know why that would be needed for DENY DELETE/ALTER but...
October 11, 2012 at 8:23 am
Ratheesh.K.Nair (10/11/2012)
What permission does that user have currently?? Is that user the owner of that table??
No, I'm the owner of all objects.
October 11, 2012 at 8:13 am
Ratheesh.K.Nair (10/11/2012)
If you want to DENY Create,Drop & Alter why cant you give a less privilege to that user??
I had then as DDL Admin but there is a bug with...
October 11, 2012 at 8:12 am
You are going to have to restore it based on the backup file.
If you want to move objects to an ndf then you will need to do so after the...
October 11, 2012 at 7:52 am
Ratheesh.K.Nair (10/11/2012)
What permission does that user have currently?? Is that user the owner of that table??
They are members of the fixed database role db_owner.
October 11, 2012 at 7:45 am
I also need to DENY ALTER SCHEMA but I'm getting an error.
Does anyone know the correct syntax?
October 11, 2012 at 7:32 am
If the Standard is to not use prefix table names and you were told not to use them then I guess you don't have any choice.
That is unless you don't...
October 2, 2012 at 7:09 am
As far as naming conventions, as a DBA I enforce them and I do not allow prefixes for tables.
If you feel comfortable with 'tbl' as a Table prefix then go...
October 2, 2012 at 6:19 am
Greg Snidow (10/1/2012)
Welsh Corgi (10/1/2012)
It is quite common in the Access world but I do not see any benefit in doing this.
My guess is that quite often the people creating...
October 1, 2012 at 5:00 pm
Viewing 15 posts - 1,156 through 1,170 (of 3,738 total)