Determine User Rights to Table

2012-11-02  Source: Original Site  Category:Visual Basic  Views:0 


I need to determine a users rights to a table.... right now, what I do is create an ADO recordset and try to READ the table to determine if the user has READ access to it or not.

I was wondering if there was a better way to this.

I need to know this when the user enters user id and pwd at the login screen to determine what tables I need to query.

The way it works is that if the user has access to a table that is say in Group A, then I need to target these Group A tables in my queries, else I need to target say Group B tables.

Users can only read Group A or Group B tables, but not both.

Any ideas are appreciated...

Related articles
  • Determine User Rights to Table 2012-11-02

    I need to determine a users rights to a table.... right now, what I do is create an ADO recordset and try to READ the table to determine if the user has READ access to it or not. I was wondering if there was a better way to this. I need to know this

  • How to determine users rights to access a file in NT, without user password 2012-06-10

    I need to determine users rights to access certain files under NT, but I don't have their passwords to open their tokens. Functions like AccessCheck() require the user token, which is obtained by LogonUser(), but it requires the user password. I foun

  • Can I set user rights to table access ? 2013-03-16

    I know that you can specify user rights on the particular database. But how about table access. Can I set rights to a particular user either for read, write for a particular table only?

  • SQL7 List of users/rights on tables-views-SP 2015-01-23

    Greetings! I'm looking for a trick by which I could extract a COMPLETE LIST of ALL USERS and their rights (INSERT/DELETE/EXECUTE etc.) on ALL OBJECTS such as tables, views and stored procedures in MSSQL 7. Via sp_table_privileges I managed to extract

  • user rights on table columns 2013-06-19

    Is there any possibility to grant select right to user on specified columns of a table ? Or do i have to create a view for this column (an grant the according rights to it) ? d.

  • Consolidated list of Oracle user rights 2012-07-26

    We're puzzling our way through an Oracle migration, and we're to the point where we'd like to start determining the roles of developers and analysts in the database. Is there a consolidated list of 'user rights', for lack of a better term, like CREAT

  • How to set user rights in ms.access from vb6 2012-03-13

    Is their any way to create user and assign user rights/permissions for any table(s) in ms.access through vb6 code (ADO / DAO). waiting for your reply. Ahmed

  • Oracle definer rights vs. user rights 2012-04-20

    I must be having a senior moment .... Trying to demo definer rights vs. user rights on execution of a procedure.. With apologies to Daniel, I created this test, and then in trying to find the answer to my question I found his nearly identical example

  • Oracle Min. user right for snapshot 2012-12-07

    I want to allow another company to access my db with few tables and create these tables as snapshot on their own db. What min. user right am i need to set to fullfil this requirements. Am i just need to grant the select user right for these object or

  • user rights 2013-04-28

    Can anyone tell me how to give users rights to create tables, see data and so on? I'm new to MS SQL Server 2000 and can't quite figure it out by myself.

  • Ubuntu can't set user rights on a file sharing server propery 2012-01-07

    I got a file sharing server on Debian. To do so, I've created a user "sharing" in which home I've created File-Sharing which is then shared on the local network. That way with the name like File-Sharing it's pretty clear what this is doing on the net

  • Amarok - How to Give User Rights to Access MP3 Player 2012-02-04

    I just installed Amarok so I can synch with my creative zen v+. I can access the device as root but not as user. I understand there is a way to give a user rights to do this but I don't know what it is. Can anyone help with this. I am running Fedora

  • Oracle SQL user rights. 2012-03-04

    I am studying SQL and for a chapter "Controlling user access" I need to create a DBA username and password. I know about the scott username with password, however it doesn't have create user rights. I want something with full control.

  • Ubuntu granting users rights to excute cardctl eject 2012-04-02

    hi Could someone point me to how I can allow all users rights to just do cardctl eject at prompt and not have to do sudo for this? Have read that if you do chmod a+x (command) this should work - this has made a difference to the error message : ioctl

  • Allow other User to create tables and view in a same single Schema 2012-04-18

    i have to create a new schema in my Oracle database and allow 4 users to create tables and views in this new schema passing through by their owner users ... Can i do this , and how ?? Thanks 4 the reply !! Bye Sidnet

  • Ubuntu Insufficient user rights change? 2012-05-24

    I tried to save a document into flash drive and got message that object not accessible due to insufficient user rights. Is there a way to change this? Deleted pictures and now don't get the message. Perhaps flash drive was full. Thought it wasn't for

  • How to easily determine user multi-selections 2012-06-16

    I want to determine user multi-selections. For example, if a user has the choice of A, B, C, D, E .... the user is able to choose none, all, or any combination such as A & B, or B, D & E. Sort of how the Msgbox() function can take parameters

  • How to Enable User rights without logging off? 2012-07-31

    My application enables the user rights but it will affect only after restart the system. How to Enable User rights without logging off? Can you give any idea or example code regarding this?

  • changing user rights permanently for external hard drive 2012-08-19

    I have an external hard drive, Model LaCie BigDisk, 500GB, USB 2.0 - connected. The file system is NTFS. I use SuSE 9.3. When I log on as root, I can read and write data on the disk, which is automatically mounted under '/media/500GB'. When I logon a

  • how 2 determine user inactivity? 2012-11-14

    how 2 determine user inactivity? thanks for the help in advance Michael B. Williams