network profile
| bio | website | |
|---|---|---|
| location | Denver, CO | |
| age | 34 | |
| visits | member for | 10 months |
| seen | May 14 at 20:59 | |
| stats | profile views | 3 |
Senior Oracle JD Edwards EnterpriseOne Developer
EnterpriseOne JD Edwards CNC Administrator
|
Apr 30 |
comment |
How to find which tables and views a user has access to? The second query worked great. Thank you for the help! |
|
Apr 30 |
accepted | How to find which tables and views a user has access to? |
|
Apr 30 |
comment |
How to find which tables and views a user has access to? Thanks Aaron - Not being extremely familiar with SQL Server Im not sure what the Authorization dbo does for the role, Im reading on it now. I will find a way to see all the tables that have an explicit deny on and remove the duplicates when I find all tables in the DB. That should provide what Im looking for correct? |
|
Apr 30 |
comment |
How to find which tables and views a user has access to? If Im understanding the question correctly, the users who connect with the FINREP user ID can access and query the tables 1-4 with no problem, but cannot access other tables. Does that help? I need to find what they have access to (whether it was granted in a manner similar to the views or unrestricted). |
|
Apr 30 |
comment |
How to find which tables and views a user has access to? The other developers may have altered this statement above to allow access to specific tables where st.name not in ('TABLE1','TABLE2','TABLE3','TABLE4') so it looks like this is not a grant back, but they do not deny all to the tables in here. Is there a way to find all of these tables? |
|
Apr 30 |
comment |
How to find which tables and views a user has access to? I posted the results above when I run your query, it shows the 2 views, but no tables... |
|
Apr 30 |
revised |
How to find which tables and views a user has access to? added 257 characters in body |
|
Apr 30 |
comment |
How to find which tables and views a user has access to? Im not sure why the authorization to dbo, the DBA set that up (DBA no longer here). But we did deny access to everything except table1, table2, table3, table4 show in the second statement. Then specifically granted back access to the single view. This was the original setup we did the for the role, however over the years other developers have granted access back to more tables, Im trying to find all the tables the user has access to so we can replicate those to a new DB. |
|
Apr 30 |
revised |
How to find which tables and views a user has access to? added 1834 characters in body |
|
Apr 30 |
comment |
How to find which tables and views a user has access to? I'll paste the command above (in original question post) that the DBA provided me when we originally created this role and access. It might help explain what we are doing, Im probably not doing a great job of explaining the setup. |
|
Apr 30 |
comment |
How to find which tables and views a user has access to? That worked for the Views but it didnt show any of the tables. This user has SELECT access only to a handful of tables, would that make a difference for this query? |
|
Apr 30 |
asked | How to find which tables and views a user has access to? |
|
Mar 27 |
awarded | Commentator |
|
Mar 27 |
comment |
Newly discovered SQL Server Express has all databases inaccessible/offline Thanks, I will read up on both Auto-Close and Auto-Shrink tonight. Would this cause all of the databases to be inaccessible on the server? I cannot expand any of the databases in the picture above, even the ones with AutoClose and AutoShrink off. |
|
Mar 27 |
revised |
Newly discovered SQL Server Express has all databases inaccessible/offline added 142 characters in body |
|
Mar 27 |
comment |
Newly discovered SQL Server Express has all databases inaccessible/offline Sorry I hit Add comment before I finished the reply above. I'll post an image to the original post with the screen shot of the query results. |
|
Mar 27 |
comment |
Newly discovered SQL Server Express has all databases inaccessible/offline 1) The failed login attempts were all by IT personnel today. 2) It looks like Auto Close it turned on for several but not all of the databases. 3) What will that RESTORE SQL statement perform? I don't want to run it in Production just yet without knowing. |
|
Mar 27 |
comment |
Newly discovered SQL Server Express has all databases inaccessible/offline @MaxVernon - Would this prevent the databases from coming online? |
|
Mar 27 |
comment |
Newly discovered SQL Server Express has all databases inaccessible/offline @ThomasStringer - the results from the query are posted above. |
|
Mar 27 |
revised |
Newly discovered SQL Server Express has all databases inaccessible/offline added 191 characters in body |
