Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. j2willi4

    reassign privileges

    thanks sqlbill!
  2. j2willi4

    reassign privileges

    well... my understanding of it is (and i could be wrong... i'm a novice) the users log into the application... the application allows the user to connect and query the db using a generic application login... so the login to the database has 2 roles providing privileges. 1) the applicationUser...
  3. j2willi4

    reassign privileges

    We have a database that has several applications accessing data from it. We want to clean up the privileges that had been assigned to the public role when the developers created those apps by reassigning them to application roles all users of the apps will belong to. we aren't taking any...
  4. j2willi4

    Guest user

    yes it did... thank you yet again!
  5. j2willi4

    Guest user

    Mufasa, Thanks, i really appreciate any help you can provide... might sound kind of odd.. but I'm not actually trying to set up a guest user account on a database... I'm not an oracle dba... or even have access to the database here... but i have been tasked with comparing and documenting some...
  6. j2willi4

    Guest user

    Is there a guest user in Oracle similar to that of MSSQL? If not, is there a guest equivalent? Thanks!
  7. j2willi4

    db2 overview

    oops... thought i did... sorry.
  8. j2willi4

    db2 overview

    hello... I am new to db2 and am trying to understand its general structure... (How does IBM term the structure... is an instance of db2 one database with many tablespaces / tables... sort of like oracle... or is it more like SQL server with many dbs in one instance with many tables per db? I...
  9. j2willi4

    db2 overview

    hello... I am new to db2 and am trying to understand its general structure... (How does IBM term the structure... is an instance of db2 one database with many tablespaces / tables... sort of like oracle... or is it more like SQL server with many dbs in one instance with many tables per db? I...
  10. j2willi4

    PUBLIC group access to stored procedures

    Do anyone know whether there are any stored procedures in ASE that PUBLIC has access to that would grant them access to data in a user database that a user doesn't have permissions to view?? In other words, can a user with no privileges to view information in a user-defined database be granted...
  11. j2willi4

    Assign a user defined role to PUBLIC

    thanks!!
  12. j2willi4

    Assign a user defined role to PUBLIC

    I am not concerned with 'should' or 'should not.' I need to figure out what it 'can' do. If 3rd party apps and DBAs didn't grant additional privs to PUBLIC, my job would be a lot simpler :) I know that in Oracle UserRole1 can be assigned to PUBLIC so that every user has the privileges of...
  13. j2willi4

    Assign a user defined role to PUBLIC

    is it possible to assign a user defined role to the PUBLIC role? and if so, is there a simple way to check that? I have seen this in oracle and informix but cant find anything on it with SQL server.
  14. j2willi4

    PUBLIC access to remote tables

    if i have a view thats base table is local, but has columns from a remote table. PUBLIC has been granted VIEW to to all local and remote tables. Will the PUBLIC's permission to the remote table be represented if I check the permissions to the remote table? try to read that 5 times fast. :) Thanks!
  15. j2willi4

    PUBLIC role access privliages

    by default" was intended to mean "has not been specifically granted any additional permissions" Other roles (non-PUBLIC) that grant permissions are out of scope for what i am doing... Thanks for all your help!
  16. j2willi4

    PUBLIC role access privliages

    Thank you for the help! Would this be an accurate statement??? Access to the SYSTEM table-space does not grant access to any user data. SYSTEM table-space is used to store system catalogue/metadata. PUBLIC, by default, does not provide a user any permissions (SELECT, DELETE, UPDATE) on user...
  17. j2willi4

    Sample Databases

    Hey... You can download sample databases straight from microsoft... There are 2 that are commonly used in examples... adventureworks is one of them... see the link below. http://www.microsoft.com/downloads/results.aspx?pocId=&freetext=adventureworks&DisplayLang=en
  18. j2willi4

    User Permission assignments

    Is there a way to determine if a privilege granted to a role (for example: PUBLIC) is default to the system, or if it has been explicitly granted by a DBA? I have seen the isMSshipped property, but haven't found much of a description about it. Does it address the above question? Thanks!
  19. j2willi4

    PUBLIC role access privliages

    Hello, Can anyone provide me with some insight or further documentation on the PUBLIC role within Oracle. I am new to Oracle. Is the role architecture in Oracle similar to that of SQL server? (Multiple DBs with in Oracle. Each DB with their own roles defined differently. Users assigned to...
  20. j2willi4

    PUBLC role access in SQL2k

    Thanks again... how did you come up with this list? did you find it online, or run a query?

Part and Inventory Search

Back
Top