Showing posts with label permission. Show all posts
Showing posts with label permission. Show all posts

Friday, March 9, 2012

HELP -URGENT: CREATE TABLE PERMISSION

Here is the situation. I want to prevent the developers to
CREATE TABLE. But if I do that the developer won't be able
to create temporary tables, which should be granted.
How do I solve this problem?Hi
When the user creates a temporary table what message does he get?
John
"Laurent Lemire" <laurentlemire@.hotmail.com> wrote in message
news:1bfe401c45227$4cf2f6d0$a301280a@.phx
.gbl...
> Here is the situation. I want to prevent the developers to
> CREATE TABLE. But if I do that the developer won't be able
> to create temporary tables, which should be granted.
> How do I solve this problem?

Sunday, February 26, 2012

Help to Create job

i want to give to my user permission to create job , add step to job etc.
i can't do this when my user do not use sa user but i don't want to give him the sa password so how can i do this
eytanb@.mekorot.co.ilBoth SPs execute permissions are default to the public role and ensure that user does have permission on MSDB database and required privilege on underlying user database.

Sunday, February 19, 2012

Help reqd on permission & security

Hi Every body,
I have newly joined this group. I am new to DB administration.
I wanted some information as to if my Server crashes (which has) & i reinstall SQL server, will restoring master database restore all my permissions & security which was set before crash. It would be great in anybody can help me on this.
Regards,
KrishnaRestoring MASTER database (rebuilding and then restoring) would get you back with your logins, default database and language assignments, and fixed server roles. The rest is stored in user databases.