Search results for query: *

thanks sqlbill!

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...

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...

yes it did... thank you yet again!

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...

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

oops... thought i did... sorry.

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...

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...

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...

thanks!!

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...

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.

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!

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!

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...

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

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!

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...

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