Viewing 15 posts - 16 through 30 (of 110 total)
Thank you for response Grant,
I installed Red Gate Soft and using but its very costly tools ,as we are in small infrastructure my management will not go for that.So am...
September 24, 2014 at 5:20 am
Thank you Mr.Suneel,
Its worked for me,But am not able to view the tables which are there under the DB.Before executing the query which you have given i can able to...
September 23, 2014 at 10:13 pm
For sp_help we will do "deny exec sp_help to public" ,
And for Deny View i used the following
"Deny view definition to public" and tried but it doesn't...
September 23, 2014 at 4:02 am
is the user member of any powerful instance level security group(s) or has the account been granted things 'on any database' ?
No,The User don't have any Instance level security and...
September 23, 2014 at 2:38 am
Hi Johan,
Thanks for your response...
I had tried that "deny view definition to Login_Name" but still that user can see the Definition of the Database only.
i had denied all the...
September 23, 2014 at 1:33 am
SELECTSUSER_SNAME(owner_sid)AS DatabaseOwner, name AS DatabaseName
FROM sys.databases
WHERE name = 'yourdb' code]
Hi Perry Whittle..
Here Login Name is :Restricted,
Db Name is :Maintain
PFA....
September 21, 2014 at 10:54 pm
Thank you for your Reply @Gail,
I am trying to remove the db_owner role to that Login but it is showing an error like
"Cannot Use the Special Principal 'dbo' ...
September 19, 2014 at 7:11 am
Hi Mr.Lempster,
Thank you for response ,I ll Try this and let you know the status.....
September 14, 2014 at 1:04 am
At last i got the solution for my Question.
By using the below Statements
deny select on sys.Columns to Login_Name,
deny select on sys.All_objects to Login_Name,
etc...
Once again thank you all for ur...
September 12, 2014 at 2:08 am
At Last i got Solution..:-):-):-):-):-):-)
September 12, 2014 at 2:03 am
Dear Tom,
I have given select access on sys.all_objects and deny select access on sys.syscolumns and sys.sql_modules for the user ,Now that user can able to get SP names but not...
September 12, 2014 at 1:51 am
Thank you Mr.Opc,
I have to do test then let you know if i get struck.
Once again thanking you...
September 11, 2014 at 10:40 pm
Thank OPC,
It's cleared for me.
Can we change the TUF file path after configuring the Logshipping....
Regards
Chowdary...
September 11, 2014 at 3:53 am
Beatrix Kiddo (9/3/2014)
According to your screenshots it should go into D:\LogShip\Backups\HIPUAE\Secondary, no?
Yes Mr.Kiddo,
It should go into D:\LogShip\Backups\HIPUAE\Secondary but it is there in the path D:\Jagadeesh\SQLDATA\HIPUAE_Secondary.
it is the DATA folder for...
September 11, 2014 at 3:32 am
If you know the database id ,Instead of giving dbid<>0 just give your database ID then check it will display all the details.....
Regards
Chowdary...
September 11, 2014 at 3:24 am
Viewing 15 posts - 16 through 30 (of 110 total)