January 25, 2008 at 2:21 am
Hello
a dbo user told he could only see the data file with manager studio on the db properties. I have no idea why.
January 25, 2008 at 1:13 pm
Not sure I've heard of this one before, but I'll throw a couple things out for you to check...
1. Perhaps explicitely give him 'backup log' in the DB properties.
2. Maybe he doesn't have OS-level perms to the drive the log is on?
What I'll do sometimes is give them sa rights to test whether they can see it then. If they can, then I know it's a rights issue and I'll then take sa away and try to snipe the rights needed. If they still can't see it with sa then I'll start looking somewhere else.
Definitely let me know what happens with this one though.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
January 28, 2008 at 2:08 am
Hello
it doesnt work.I affected the user to the schema DB_Backupoperator.
I must say it s a sql login not a windows one.
But it s trange for me
January 28, 2008 at 7:58 am
OK, let's isolate the problem. Give him sa and have him connect from his workstation. Then have him connect from another box. This way we'll see if the problem is on the server or his workstation. Of course you can just have him connect from another workstation first to see if that fixes it. If so, then reinstall his client tools. If not, then give him sa and try again from both workstations. Once you're able to get him to see the log, then you can take him out of sa and snipe the specific permissions.
Perhaps also try giving him 'view server state'. Just guessing.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
January 28, 2008 at 8:02 am
with SA rights, the user see the log file.
January 28, 2008 at 8:10 am
Excellent... now it's just a matter of time.
Did we ever establish SQL2K or 2K5?
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
January 28, 2008 at 8:13 am
its sql2005
January 28, 2008 at 8:28 am
Go into DB properties and give him 'view database state'. I'm having a hard time finding all the perms that gives, but it sounds like a good place to start. If that doesn't work, then start giving him perms in that list until something works. Backup log is probably a good one too.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
January 28, 2008 at 8:34 am
i see "view any database" or "view server state" but i dont see "view database state". Sorry
January 28, 2008 at 8:39 am
It's in db properties, not server properties.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
January 28, 2008 at 8:44 am
yes in DB properties... i mean my DB called NETEQCRECETTE and i look at propertie from this DB. Correct?
January 28, 2008 at 8:48 am
Correct.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
January 28, 2008 at 9:10 am
when i scroll to db properties , permissions, add users or role, i cant see the login i am looking for.
I only have public and guest.
Strange!
In the security part, the user is "sqli" but his username is DBO.
I dont have any idea how it could happens.
January 28, 2008 at 9:16 am
Sounds like you've got some issues to work out then...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
January 28, 2008 at 9:19 am
thanks, i will work around and give the solution when i found it.
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply