disabling owner
-
Is it possible by an administrator to disable the owner from dropping the view which created by himself?
Please guide me...
-
I don't think so. Why do you want to DISALLOW someone from DROP of an object they CREATE?
Good Hunting!AJ Ahrens
webmaster@kritter.net -
For some security reasons, i need to avoid the user who is the owner of the object once he created, that should not be dropped by any user in sql server. That only should have been done by the administrator.
-
If that is your criteria THEN
DISALLOW ANYONE the ability to CREATE anything and leave that to the Administrator ONLY. That is the only way to do this that I know of..
Good Hunting!AJ Ahrens
webmaster@kritter.net -
You could create another view yourself, and specify WITH SCHEMABINDING. That way the other view (owned by the person who shall not be allowed to drop it) cannot be dropped unless the new view is dropped, and since you are the owner of that view you are stopping that.
-
WOW... always another way
. -
And I pretty nice way as well, I think.
-
Hehe... show him who's GOD
. -
Hi,
As i read this very late.sorry for that but u can ristict ur database administrator for not droping a use .u create a extended stored procedure from that user.
then ur database administraor cannot delete ur user.
but there are many other ways to remove a user from the database.
sufian
-
Hi,
I got ur questation. U wanted that if ur user had created any achema then that ur should not delete that schema . yes u can do that u have to see that what roles that ur had been assigned, if u had given him the permission on one database and that ur is not allowed to get into master database . then u can write a script which will create a procedure in msterdatabase having refrensed of all the table names used by that user.
then the user cannot delete that schema.
if any confusion then feel free to ask for script.
from
sufian
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply