DBO user cannot see the log file in the property tab

Question

Post reply

DBO user cannot see the log file in the property tab

fred2002

SSCrazy

Points: 2943
More actions
January 25, 2008 at 2:21 am

#183396

Hello
a dbo user told he could only see the data file with manager studio on the db properties. I have no idea why.

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

KenpoDBA SSCrazy Eights Points: 9811 More actions · Answer 1

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

Minion Maintenance is FREE:

fred2002 SSCrazy Points: 2943 More actions · Answer 2

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

KenpoDBA SSCrazy Eights Points: 9811 More actions · Answer 3

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

Minion Maintenance is FREE:

fred2002 SSCrazy Points: 2943 More actions · Answer 4

fred2002

SSCrazy

Points: 2943

January 28, 2008 at 8:02 am

#772437

with SA rights, the user see the log file.

KenpoDBA SSCrazy Eights Points: 9811 More actions · Answer 5

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

Minion Maintenance is FREE:

fred2002 SSCrazy Points: 2943 More actions · Answer 6

fred2002

SSCrazy

Points: 2943

January 28, 2008 at 8:13 am

#772449

its sql2005

KenpoDBA SSCrazy Eights Points: 9811 More actions · Answer 7

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

Minion Maintenance is FREE:

fred2002 SSCrazy Points: 2943 More actions · Answer 8

i see "view any database" or "view server state" but i dont see "view database state". Sorry

KenpoDBA SSCrazy Eights Points: 9811 More actions · Answer 9

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

Minion Maintenance is FREE:

fred2002 SSCrazy Points: 2943 More actions · Answer 10

yes in DB properties... i mean my DB called NETEQCRECETTE and i look at propertie from this DB. Correct?

KenpoDBA SSCrazy Eights Points: 9811 More actions · Answer 11

Correct.

Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant

Minion Maintenance is FREE:

fred2002 SSCrazy Points: 2943 More actions · Answer 12

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.

KenpoDBA SSCrazy Eights Points: 9811 More actions · Answer 13

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

Minion Maintenance is FREE:

fred2002 SSCrazy Points: 2943 More actions · Answer 14

thanks, i will work around and give the solution when i found it.