July 22, 2011 at 9:29 am
I am having a dbo owner permission on a the database even though i am unable to access some of the tables in that database.i am using sqlserver 2000 version.
My question is if i am having dbo owner permission then i have to access every table but why i am unable to acccess the some of the tables.
can any one do a need ful.............
July 22, 2011 at 9:41 am
Not sure what the question is here.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
July 22, 2011 at 10:21 am
I am having a dbo owner permission on a the database even though i am unable to access some of the tables in that database.i am using sqlserver 2000 version.
My question is if i am having dbo owner permission then i have to access every table but why i am unable to acccess the some of the tables.
July 22, 2011 at 10:24 am
The permission may have been revoked for some tables for that user.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
July 22, 2011 at 10:34 am
tables was not revoked.....
July 22, 2011 at 10:52 am
vijay82
What Sean is trying to tell you is you need to provide more information. we can not run down a cloud in the sky wwithout a plane. Post scripts, error messages, and any other information that would help us help you.
July 24, 2011 at 8:19 am
The below is the error which i am getting while access the table.
"
Unexpected error happened during this operations
you might not hav permission to perform this operation or the object might no longer exist in the database
"
But i could see the table in the database.
thanks.......
July 25, 2011 at 7:09 am
What operation? select, insert, update, delete, drop, truncate, alter? What table level permissions does the user have? We keep asking for some details and you are not providing anything to go on. The error message you posted is due to permissions.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
July 27, 2011 at 2:17 am
vijay82 (7/22/2011)
My question is if i am having dbo owner permission then i have to access every table but why i am unable to acccess the some of the tables.
Eventhough you have dbo owner permission on the database, DBA has DENYed acces to some of the tables to you.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply