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...
Regards
Chowdary...
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...
Regards
Chowdary...
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...
Regards
Chowdary...
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...
Regards
Chowdary...
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...
Regards
Chowdary...
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....
Regards
Chowdary...
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' ...
Regards
Chowdary...
September 19, 2014 at 7:11 am
Hi Mr.Lempster,
Thank you for response ,I ll Try this and let you know the status.....
Regards
Chowdary...
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...
Regards
Chowdary...
September 12, 2014 at 2:08 am
At Last i got Solution..:-):-):-):-):-):-)
Regards
Chowdary...
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...
Regards
Chowdary...
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...
Regards
Chowdary...
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...
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...
Regards
Chowdary...
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...
Regards
Chowdary...
September 11, 2014 at 3:24 am
Viewing 15 posts - 16 through 30 (of 110 total)