What do u mean by refersh?

U dont know the ACID Property.

Thanks it works...,

use [test]

GO

DENY SELECT ON SCHEMA::[sqluser_schema] TO [sqluser1]

GO

Error: Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.

--------------------------------------------------------------------

using

Execute As User='sqluser1'

Looping

I promise I am not making this stuff up

Things to check:

1) are you in the right database?

2) does the username sqluser1 exist in that database?

3) do you have sa...

Currently what is the situation?

What files u have?Mdf,ldf..size of files..

Thanks..

EXECUTE AS USER='sqluser1'

is giving error:

Msg 15517, Level 16, State 1, Line 1

Cannot execute as the database principal because the principal "sqluser1" does not exist, this type of principal cannot...

Thanx..Gila

Like in MSDN we something propose as answer and it means that it is finished,There is no such feature in SScentral.:-)

Thanx..

By mistake I have run the sqluser1.

Problem is still same I want to test the user sqluser1's permission:-)

After making entry in reverse lookup in DNS it is OK..

Dear Syed,

U mean to say,

If We are taking a backup from Query Editor then the service account of SQL Server Service is impersonate.

If a Job is taking a backup then...

Login as that user and try to do some inserts and selects on objects that belong to that schema. You can do that directly in SSMS easily enough.

Thanks...But How...

Thanx..

But in AD only Windows login will display,How Will I check the permission of a SQL Login?

Please more clear it...

Thanx Gila,

The no. of input of posts in sql server central is very high and my post is old within 1 hour.Due to which I comment on older posts and...

My sql server agent service is not starting after doing this..It is a cluster..